Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Sherif Shehab
Ranch Hand
Posts: 487
Android Eclipse IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ??
 
ujjwal soni
Ranch Hand
Posts: 403
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

Add an exception in your firewall for port 1433.

 
Sherif Shehab
Ranch Hand
Posts: 487
Android Eclipse IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 403
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 487
Android Eclipse IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi ,

How can i check if this port 1433 is opened on the server machine or not ?
 
ujjwal soni
Ranch Hand
Posts: 403
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

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

 
Sherif Shehab
Ranch Hand
Posts: 487
Android Eclipse IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i wrote this means that the port is locked right ?
 
Nikolaos Katzuriakis
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There should be no colon there. The correct syntax is .

Sherif Shehab wrote:i wrote this means that the port is locked right ?


For troubleshooting this, it's worth following the
http://support.microsoft.com/kb/313178

as already mentioned, and also (if you are connecting to a named instance)
http://support.microsoft.com/kb/313225.

Also, this bug might be affecting you
http://support.microsoft.com/kb/306865.

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic