Rank: Advanced Member
Groups: Registered
Joined: 1/20/2017(UTC) Posts: 59  Location: sussex Thanks: 1 times
|
I have 2 instances of sql server. One listens to 1433 and the other on 1434. To make the connection to access the data I usuallly just put in the dns mapped name of the server eg. data.myserver.co.uk and this works with one instance on 1433. How do I connect to 1434 for the other instance as I tried data.myserver.co.uk:1434 but this does not connect. Is there a setting in the background I can change. Also is there a way of editing existing connection strings, espcially as a global change.
Regards Nigel
Don't worry about this now. After looking further I found the connection is dns name and then comma and port number eg. data.myserver.co.uk, 1434 and there is a replace function for connections under projects.
|
|
|
|
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.