Can not connect to a SQL instance on over the network
Posted on 2014-12-10
I am struggling to connect to a SQL instance from SQL management Studio installed on another server. I have been able to do so until recently and it is not clear what may have caused this. Here are the symptoms:
When i try to connect to Server\Instance using SQL management studio, i get "a network related or instance specific error has occured...."
When i connect to Server\ (no instance, i.e. default uinstance) it connects no problem.
The server names resolve correctly from both sides and all protocols are enabled in SQL config on both sides.
Port 1433 is open. (1434 is not used in this environment).
Any help would be greatly appreciated.