I am experiencing an issue where my instance of SQL Server Management Studio 2014 will not connect to any of our production clustered SQL 2000 and 2005 instances. It will however connect to non-clustered 2000, 2005 and 2014 instances without issue.
I can connect to our clustered instances via SQL Server Management Studio 2005 without issue.
It used to work, stopped a month or so back and I just haven't been able to resolve it yet. The other three team members can all connect with SSMS2014 without an issue, it's just my machine. I have performed a repair on SSMS2014 install but this has not helped.
I have no access to the servers as they are our production servers, so cannot make any changes to them. Also the fact that three other team members can connect indicates to me it is NOT server specific by is instead client specific.
Error message:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified)
Thanks in advance.
Best Answer
Windows Firewall is blocking sql server 2005 clustered instance connection. It needs UDP 1434 to be open. The down voted reply put me on the right path.
Mariano C.
MS Support