Connecting to difference sql server instance on the same server

Comments

3 comments

  • Avatar
    Michael Becker

    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
  • Avatar
    Weinan Sun

    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
  • Avatar
    Michael Becker

    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.