Connecting to named instance of Microsoft SQL Server

Question

I am trying to connect Excel to Microsoft SQL Server, the problem is there are two named instances of server.

default instance (localhost)
SRV1 instance

when I connect using COMPUTER_NAME or IP address, I get connected to the default instance, but I need to connect to SRV1.

I tried COMPUTER_NAME/SRV1 and IP_ADDRESS/SRV1, both did not work. I need help thank you very much.

Roger Wolf · Accepted Answer · 2018-07-31 04:06:32Z

1

The COMPUTER_NAME\SRV1 syntax will give you what you need, but only if the SQL Browser service is running on that box. If not, you will need to know the port which the named instance is configured to listen on, and specify the server name in the ipaddr,port_number format (yes, the separator is a comma, not a colon).

answered Jul 31, 2018 at 4:06

Roger Wolf

7,7872 gold badges29 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Wesley Snopes Over a year ago

Adding the port number worked for me! Thank you very much sir! You saved me.

Collectives™ on Stack Overflow

Connecting to named instance of Microsoft SQL Server

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related