This week's book giveaway is in the Kotlin forum.
We're giving away four copies of Kotlin in Action and have Dmitry Jemerov & Svetlana Isakova on-line!
See this thread for details.
Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

unable to connect to a SQL server  RSS feed

 
Kingsley Mullers
Ranch Hand
Posts: 48
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi there,

i'm trying to connect to a MS SQL Server 2000, and its giving this error:
"java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket". The port number is 1433 and the settings look fine as well.
when i ping it or telneting it i can talk to it but when trying out my code it gives me the above error. whats funny enough is i have another SQL Server that i can connect to which means my code is fine but when i put in the details of the other server is doesnt works, what could be the problem here, is it with the server box or maybe authentication

many thanks
 
basha khan
Ranch Hand
Posts: 516
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Do u created a new instance of SQL server and trying to connect?.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!