• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Liutauras Vilda
  • Campbell Ritchie
  • Tim Cooke
  • Bear Bibeault
  • Devaka Cooray
Sheriffs:
  • Jeanne Boyarsky
  • Knute Snortum
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Ganesh Patekar
  • Stephan van Hulst
  • Pete Letkeman
  • Carey Brown
Bartenders:
  • Tim Holloway
  • Ron McLeod
  • Vijitha Kumara

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

 
Ranch Hand
Posts: 492
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 ??
 
Ranch Hand
Posts: 405
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

Add an exception in your firewall for port 1433.

 
S Shehab
Ranch Hand
Posts: 492
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: 405
  • 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
 
S Shehab
Ranch Hand
Posts: 492
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: 405
  • 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.

 
S Shehab
Ranch Hand
Posts: 492
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 ?
 
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.

 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!