File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket" Watch "[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket" New topic
Author

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

Sherif Shehab
Ranch Hand

Joined: Mar 05, 2007
Posts: 483

Hi guys

I'm trying to connect to Microsoft Sql 2000 server via JDBC , i got this exception
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 ??


Thanks,
Sherif
ujjwal soni
Ranch Hand

Joined: Mar 28, 2007
Posts: 403
Hi,

Add an exception in your firewall for port 1433.


Cheers!!!
Ujjwal B Soni <baroda, gujarat, india> <+919909981973>
"Helping hands are better than praying lips......"
Sherif Shehab
Ranch Hand

Joined: Mar 05, 2007
Posts: 483

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
Ranch Hand

Joined: Mar 28, 2007
Posts: 403
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
Ranch Hand

Joined: Mar 05, 2007
Posts: 483

Hi ,

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

Joined: Mar 28, 2007
Posts: 403
Hi,

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

Sherif Shehab
Ranch Hand

Joined: Mar 05, 2007
Posts: 483

i wrote this means that the port is locked right ?
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket
 
Similar Threads
[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing
Error Establishing Socket
SQL Connection Error
unable to connect to a SQL server
SQL Exception -Error establishing socket