Connecting to a specific SQL Server instance?
740713Mar 2 2010 — edited Mar 3 2010Hi all,
I create a new connection for SQL Server, specify the host and the port number that SQL Browser is listening on (my servers have dynamic ports, not static), and I can connect succesfully to the local SQL Server Instance on that machine, which is SQL Server 2000. However, I also have a SQL Server 2005 and 2008 running on that machine as well, and wish to connect to them.
The SQL Server tab doesn't ask for an instance name at all, so I don't know how to do that. I suppose I could make my ports static for each instance, but the point of using SQL Browser is that you don't need to do that. SQL Browser acts almost like a DNS server for any sql requests coming to that machine.
Is there any way to specify which instance name you want to connect to rather than a port #?