[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket

[Sherif Shehab]

Hi guys

I'm trying to connect to Microsoft Sql 2000 server via JDBC , i got this exception

  [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.  

i trying to solve the problem by :
1- checking the SQL server service pack i found it SP3 .
2 -checked the TCP/IP connection properties on the Server and the default port 1433 .
3- i checked this and was OK

so it's seems all fine but i still cant connect . Any thing i'm missing ??

[ujjwal soni]

Hi,

Add an exception in your firewall for port 1433.

[Sherif Shehab]

ujjwal soni wrote:Hi,

Add an exception in your firewall for port 1433.

Hi ,

Which side do you mean the firewall for the Client that wants to connect to the SQL server (in this case my pc ) or the firewall for the Microsoft SQL serv

[ujjwal soni]

Hi,

You need to add an exception on the server's firewall to allow incoming client connections.

Refer to below link for more details.. http://support.microsoft.com/kb/313178

[Sherif Shehab]

Hi ,

How can i check if this port 1433 is opened on the server machine or not ?

[ujjwal soni]

Hi,

Use telnet xxx.xx.xx.xx 1433 to check 1433 port is opened or not.

[Sherif Shehab]

i wrote

 telnet 10.65.1.247:1433   Connecting To 10.65.1.247:1433...Could not open connection to the host, on port 23: Connect failed  

this means that the port is locked right ?