Showing posts with label nameddevsql. Show all posts
Showing posts with label nameddevsql. Show all posts

Friday, March 23, 2012

How to connect second instance if server has two instance?

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?
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