How to connect second instance if server has two instance?

How to connect second instance if server has two instance?

Post by ABC » Thu, 25 Jan 2007 15:24:13


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?
 
 
 

How to connect second instance if server has two instance?

Post by Jens » Thu, 25 Jan 2007 16:19:50

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.yqcomputer.com/
---