- You try to connect to an instance of SQL Server 2000 that is installed on a computer that is running Microsoft Windows Server 2003.
- You try to connect to an instance of SQL Server 2000 from a remote computer on your network.
Additionally, you may receive one of the following error messages:
Error message 1
[TCP/IP Sockets]SQL Server does not exist or access denied.
[TCP/IP Sockets]ConnectionOpen (Connect()).
Error message 2
Unable to connect to server <SQL Server Instance Name>:
Server: Msg 17, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.
Error message 3
SQL Server Error: 10061
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).
SQL Server Error: 11
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation.
Note You may also notice this behavior when you try to connect to an instance of Microsoft SQL Server 2000 Service Pack 3 (SP3) or to a later version of SQL Server 2000 that is installed on a computer that is running Window Server 2003, if the instance of SQL Server 2000 SP2 or the earlier version of SQL Server 2000 is installed on the same computer.
For additional information about how to obtain latest service pack for SQL Server 2000, click the following article number to view the article in the Microsoft Knowledge Base:
Note You cannot work around this problem. You must upgrade all the instances of SQL Server 2000 to SQL Server 2000 SP3 or to a later version of SQL Server 2000.
Event ID: 1
Time: 5:29:24 AM
Computer: <Computer Name>
You are running a version of Microsoft SQL Server 2000 or Microsoft SQL Server 2000 Desktop Engine (also called MSDE) that has known security vulnerabilities when used in conjunction with the Microsoft Windows Server 2003 family. To reduce your computer's vulnerability to certain virus attacks, the TCP/IP and UDP network ports of Microsoft SQL Server 2000, MSDE, or both have been disabled. To enable these ports, you must install a patch, or the most recent service pack for Microsoft SQL Server 2000 or MSDE from http://technet.microsoft.com/en-us/sqlserver/bb331754.aspx
For more information, see Help and Support Center at http://support.microsoft.com.
Article ID: 884012 - Last Review: 12 Sep 2008 - Revision: 1