[SQLServer 2000 Driver for JDBC]Error establishing socket.
原链接地址
1. Make sure that SQL Server is set to mixed authentication. To do this, open enterprise manager, right click on server/properties; go to security tab and select SQL Server and Windows Authentication. Apparently, the driver from Microsoft cannot handle windows integrated authentication.
2. Keeping the server properties dialog up, go to the general tab and push the network configuration button. Enable TCP/IP (it is disabled by default). If you wish, press properties to change the default port (1433).
3. Add an SQL Server login account (NOT a WINDOWS account (see 1)). You can also use your sa account, but I don't recommend it.
4. Use the login setup in step 3.
Some final notes:
(1) I've seen ads for third party drivers that can use Windows integrated authentication. Try one if you need this feature.
(2) One responder suggested telneting to port 1433 to verify TCP connectivity. The connection is refused on my machine even though I can connect through the driver. And this is how it should be; otherwise there'd be a security risk.