This week's book giveaway is in the Kotlin forum.
We're giving away four copies of Kotlin for Android App Development and have Peter Sommerhoff on-line!
See this thread for details.
Win a copy of Kotlin for Android App Development this week in the Kotlin forum!
  • 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:
  • Campbell Ritchie
  • Liutauras Vilda
  • Devaka Cooray
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Junilu Lacar
  • Paul Clapham
  • Knute Snortum
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • salvin francis
  • Carey Brown
Bartenders:
  • Tim Holloway
  • Frits Walraven
  • Ganesh Patekar

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

 
Ranch Hand
Posts: 493
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: 493
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: 493
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: 493
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.

 
All of the world's problems can be solved in a garden - Geoff Lawton. Tiny ad:
RavenDB is an Open Source NoSQL Database that’s fully transactional (ACID) across your database
https://coderanch.com/t/704633/RavenDB-Open-Source-NoSQL-Database
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!