MSSQL异常：JDBC连接SqlServer2000出现"Connection refused: connect"解决方案

For this kind of database connection problem, there are always two distinct issues:

1. The SQL server itself is not running or TCP/IP is disabled. That can be confirmed by runnetstat

   and see it is listed there. And then run

   telnet localhost 1433

   and see it can connect (or whatever port number).

2. Even if the server is running, a client program such like jdbc may still fail to connect to it because of afirewall

   For testing, you can turn off the XP firewall. And if you have other firewall running, check the firewall log and see any activities that might be related.

You can also verify whether or not your server is running from the

SQL Server Network Utilityon the server, or from another client utility such as

SQL Query Analyzer

or a command line utility such as

osql

To check the enabled protocols for a server, follow these steps:

1. In SQL Server 2000, start the SQL Server Network Utility (svrnetcn.exe).
2. On the General tab, select the instance of Microsoft SQL Server on which to load an installed server network library.
3. Make sure that TCP/IP appears in the Enabled Protocols list.
4. To find the port number, in the Enabled Protocols list, click TCP/IP, and then click Properties. The Properties dialog box displays the port number.

There is an known bug: SQL Server May Not Listen on TCP/IP Sockets When TCP/IP is the Only Protocol

In a SQL Server 2000 custom installation, if TCP/IP is the only selected protocol and all other protocols are disabled, SQL Server may not initialize and listen on TCP/IP sockets. The Server Network Utility shows that it is listening only on TCP/IP port 1433 even though it is not. To identify if SQL Server is not listening on TCP/IP, check to see if the value for TcpPort in the following registry key is incorrectly set to blank or empty:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\ [Instance Name]\MSSQLServer\SuperSocketNetLib\Tcp\REG_SZ TcpPort=

To work around this problem, follow these steps:

1. Start Registry Editor (Regedt32.exe).
2. Locate the TcpPort value in the following key in the registry:Named instance:
   HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\[InstanceName]\MSSQLServer\SuperSocketNetLib\Tcp\TcpPort

   Default instance:
   HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer

    1/2    1 2 下一页 尾页