For those who face error 26 for SQL Server 2005 installed on Windows Server 2008
Named instances of SQL server connect to dynamic TCP Ports instead of default 1433. To make it feasible for clients to connect to named instances, you need to run SQL Server Browser that connects to UDP 1434 and listens to incoming client requests.
Hence for named instances of Sql Server:
i) Sql Server instance should be running : Check SQL Server Configuration manager
ii) Sql Server Browser should be running : Check SQL Server configuration manager, use netstat to make sure UDP 1434 is in use
iii) Make sure firewall is allowing connections:
In windows server 2008 this is the main issue as you cannot reach the firewall from network connection. You can reach the firewall by running the ServerManager/Configuration/Windows firewall with advanced security
It took me couple of hours and ethereal packet capture to figure out that server was dropping the packages. Hope it helps.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment