May 7, 2018 at 8:48 am
Hi,
I need help with setting connection string in SSMS to named instance of SQL2017
I have a non domain Win2012 server located in Data Center in Canada
applications access server using sql authentication
servername='myserver1.datacan.net'
win2012 computer name ='CANSQLSERVER1'
When I setup connection from SSMS to default instance(SQL2012) on port 1433
I specify
On login tab
Server name =CANSQLSERVER1
login = 'myUser'
password ='****'
On Additional Connection Parameters
server ='myserver1.datacan.net'
Those setting working fine
I am specifying connection this way because I am managing replication on this server and replication console does not open if "server name" other then computer name
and I don't want to rename "server name" with sp_dropserver/sp_addserver
I installed name instance"SQL2V2017" of SQL2017 on CANSQLSERVER1 and set tcp/ip to port to 50000
When I create connection to SQL2V2017 using SSMS I set
On login tab
Server name =CANSQLSERVER1\SQL2V2017,50000
login = 'myUser1'
password ='****'
On Additional Connection Parameters
server ='myserver1.datacan.net'
BUT at this case I get connected to default instance(SQL2017)
Question: how correctly specify connection string from SSMS to SQL2V2017 in my case
I can succesfully connect specifying
On login tab
Server name =Cmyserver1.datacan.net,50000
login = 'myUser1'
password ='****'
but as said I need "CANSQLSERVER1\SQL2V2017" to manage replication
Thank you
Alex
May 7, 2018 at 9:58 am
ebooklub - Monday, May 7, 2018 8:48 AMHi,
I need help with setting connection string in SSMS to named instance of SQL2017I have a non domain Win2012 server located in Data Center in Canada
applications access server using sql authentication
servername='myserver1.datacan.net'
win2012 computer name ='CANSQLSERVER1'When I setup connection from SSMS to default instance(SQL2012) on port 1433
I specify
On login tab
Server name =CANSQLSERVER1
login = 'myUser'
password ='****'On Additional Connection Parameters
server ='myserver1.datacan.net'Those setting working fine
I am specifying connection this way because I am managing replication on this server and replication console does not open if "server name" other then computer name
and I don't want to rename "server name" with sp_dropserver/sp_addserverI installed name instance"SQL2V2017" of SQL2017 on CANSQLSERVER1 and set tcp/ip to port to 50000
When I create connection to SQL2V2017 using SSMS I set
On login tab
Server name =CANSQLSERVER1\SQL2V2017,50000
login = 'myUser1'
password ='****'On Additional Connection Parameters
server ='myserver1.datacan.net'BUT at this case I get connected to default instance(SQL2017)
Question: how correctly specify connection string from SSMS to SQL2V2017 in my case
I can succesfully connect specifying
On login tab
Server name =Cmyserver1.datacan.net,50000
login = 'myUser1'
password ='****'but as said I need "CANSQLSERVER1\SQL2V2017" to manage replication
Thank you
Alex
Try removing the additional connection parameters where you entered: server ='myserver1.datacan.net'
The connection string parameters override anything you have set earlier for the rest of the connection. So it will ignore CANSQLSERVER1\SQL2V2017,50000
Also as an FYI...if you have something out of the ordinary for a server name, port in replication, for connections to that server you can use an alias on the servers involved in replication to point to the correct server name and port.
Sue
May 7, 2018 at 11:40 am
Thank for the tip!
I did not no that that additional parameters overwrite ..values
Managed to connect as
On login tab
Server name =CANSQLSERVER1\SQL2V2017
login = 'myUser1'
password ='****'
On Additional Connection Parameters
server ='myserver1.datacan.net,50000'
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply