question

Troy_2012 avatar image
Troy_2012 asked

Connect Name Instance Remotly

Hi everyone I have 3 servers : **AD,Server1 and Server2**. The **Server1** and **Server2** are member in the **DC** domain name on Server **AD**. on **Server1** I installed **Default instance** SQL Server2012, on **Server2** installed Default instance and name instance [SQLIns]. To open access to SQL Server when using dynamic ports ,I added inbound rule on **server2 Firewall** C:\Program Files\Microsoft SQL Server\**MSSQL11.SQLIns**\MSSQL\Binn\sqlservr.exe And for default instance I add another inbound role in server 2 firewall C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\sqlservr.exe From **Server1** I tried to connect the Default instance on **server2** remotely and it's succeeded. But from **Server1** to connect name instance [**SQLIns**] on **server2** remotely it failed, It succeeded when I put port number **Server2\\SQLIns,63955**. Is there any suggestion to connect remotely without use the port number for name instance SQLIns ? OS win Server 2012 R2 Standard
sql-server-2012
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Troy_2012 avatar image
Troy_2012 answered
I solved it... Just add another inbound for SQL Server Browser
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image
ThomasRushton answered
Is the SQL Browser service running? If not, fire it up and have another go...
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Yes ,on Server2 the SQL Browser service is running and the service is under Built-in account"local service" , the other serveries run under "NT Service\MSSQLSERVER"
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.