SQL Server – Troubleshooting Remote Connection to Named Instance

sql server

I have a server with 2 SQL Server instances, I can connect to the default instance remotely, however I am not able to connect to the named instance.

enter image description here

enter image description here

enter image description here

When I try to connect remotely, I get this error, SQL Server is configured to allow remote connection and the name is correct

enter image description here

Best Answer

Try connecting to 311SQLI01,1430. If that works, turn on the SQL Browser service.

SQL Browser needs to be turned on for port number translation ( it's off in your screenshot ) and you don't seem to be referencing the specific port in your connection attempts.

Related Question