For those who face error 26 for SQL Server 2005 installed on Windows Server 2008
Named instances of SQL server connect to dynamic TCP/IP Ports instead of default 1433. SQL Server Browser which is listening on 1434 , respond to the client request and returns the TCP/IP port or named pipe associated with the requested SQL Server instance.
On Windows 2008 Server you need to configure your firewall for requests coming on UDP 1434
Check if Sql Server instance is running in SQL Server Configuration manager
Check if Sql Server Browser is running in SQL Server Configuration manager. (You can use netstat to make sure UDP 1434 is in use)
Check if firewall is allowing connections
On Windows 2008 Server you need to configure your firewall for requests coming on UDP 1434
Check if Sql Server instance is running in SQL Server Configuration manager
Check if Sql Server Browser is running in SQL Server Configuration manager. (You can use netstat to make sure UDP 1434 is in use)
Check if firewall is allowing connections
To open Windows server 2008 firewall go to ServerManager/Configuration/Windows firewall
No comments:
Post a Comment