Connecting to difference sql server instance on the same server

Follow

Weinan Sun

January 14, 2019 17:41

I have a server with 2 different instance on it. I'm connecting to the server with the IP address of that server. However, it will only gave me the default instance when i actually wants to connect to the 2nd instance. Can anyone help on how should i be able to connect to the other instance?

 

Thanks!

0

• 

  Michael Becker January 14, 2019 17:53

  Hi Weinan,

  if you have multiple instances of MSSQL, you will have them running under different names. What you need to do is to put in the server address: IP address(or domain name) / MSSQL serve instance name. Yo ucan find out the name of teh instance by goign to Task Manager -> Services tab, and find SQL Server service. Teh name in the parenthesis in there is you instance name.

  if you are connecting to localhost, and you have two instances, one named MSSQLSERVER and the other TESTSQLSERVER. Then yo uhave to connect  to them like this:

  localhost\MSSQLSERVER or localhost\TESTSQLSERVER. Hope it helps.

  Regards,

  Michał

  0

  Comment actions Permalink
• 

  Weinan Sun January 14, 2019 18:11

  Hi Michael,

   

  thank you for the comment, i have 2 instance where each named sql2016 and sqldev.

  So what i would do is Ip address/sql2016 to connect to sql2016 and IP address/sqldev to connect to the second one?

   

  Thanks for answering

  0

  Comment actions Permalink
• 

  Michael Becker January 14, 2019 18:14

  Exactly. that should allow you to connect to different instances. it could be either / or \ - I don't remember that from the top of my head now

  0

  Comment actions Permalink

Please sign in to leave a comment.