Wednesday, August 09, 2006

Verify TCP connectivity for MS SQL

Installed MS SQL Server on a laptop but can not connect to it. Get error:
"java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket".

To verify TCP connectivity for MS SQL Server:
C:\ >telnet 192.168.0.131 1433
Connecting To 192.168.0.131...Could not open connection to the host, on port 143
3: Connect failed

If I telnet to another MS SQL server:
C:\ >telnet 192.168.0.151 1433

The screen goes blank, indicating telnet OK.

Installing a service pack solved the problem. Now telnet gets a blank screen instead of error message. JDBC code also worked.

0 Comments:

Post a Comment

<< Home