all groups > sql server connect > january 2007 >
You're in the

sql server connect

group:

How to connect second instance if server has two instance?


Re: How to connect second instance if server has two instance? Jens
1/23/2007 11:19:50 PM
sql server connect:
Hi,

you will have to provide either the instancename or the portnumber in
the conenctionstring or you connection dialog of choice:

Servername\InstanceName (If SQL Browser is activated it will redirect
the request to the appropiate listerner of the instance

or

Servername,portnumber

HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---
How to connect second instance if server has two instance? ABC
1/24/2007 2:24:13 PM
We have one sql server 2005 machine which have two instance named:
DEVSQL(default server named when first installed) and DEVSQL\TESTING (second
installed). On the client, I can connect default instance, but the second
instance cannot connect. What settings I should to do?

AddThis Social Bookmark Button