Keywords: SQL Server 2000, SQL2000, Fail to connect from remote machines, Windows XP, WinXP,
Windows 7, Win7, SP4, Firewall
Environment:
I have a SQL2000 installed on a WinXP. I can access the database with the sa account on that WinXP machine. But when from a remote machine (Win7), using SQL Server Management Studio of SQL Server 2008 R2, i get following exception when logging with the same sa account.
Exception:
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)
Resolution:
1. Install SP4 for SQL Server 2000.
2. Shutdown the firewall or add sqlservr.exe into the firewall's exception list.
(C:Program FilesMicrosoft SQL ServerMSSQL$SQL2000Binnsqlservr.exe)
References: