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