JDBC - connect timed out to SQL Server 2000

[thesti]

hello,

i tried to connect to SQL Server 2000 on my localhost through JDBC. i used the Microsoft SQL Server JDBC Driver 2.0, i was trying to add a new Entity Class from Databases... in Netbean 6.7.1

i couldnt make it, as i got the following error

Unable to add connection. Cannot establish a connection to
jdbc:sqlserver://localhost:1433;databaseName=Northwind using 
com.microsoft.sqlserver.jdbc.SQLServerDriver (The TCP/IP connection 
to the host localhost, port 1433 has failed. Error: "connect timed out. 
Verify the connaction propoerties, check that an instance of SQL 
Server is running on the host and accepting TCP/IP connections 
at the port, and that no firewall is blocking TCP connections to the port.".).
 

i've verified through Server Network Utility the the TCP/IP protocol is enabled and is listening on port 1433. but when i run the command "netstat -an" i don't see any service listening on port 1433.

i can connect to the database server through the query analyzer though,
what's possibly wrong? has there been any issue regarding to this?

Thank you.

[Dököll]

Hey thesti!

Add the code in question, we recently switched to SQL 2005 from 2000. Not quick to say I know SQL Server like the back of my hands but there were times when I thought there must be a better way, I don't say that anymore.

Also, you may need credentials to connect your app to the server.

I would do some of the critical steps first. Write code that you know will work as far as a connection, so you can isolate the server being the issue.

Simple JDBC/ODBC connections with datasource:

 
sun.jdbc.odbc.JdbcOdbcDriver
jdbc:odbc:Northwind
 
 

Which means you'd need to try and connect to an Access database via Administrative Tools. If you can connect, then it is not your code or the server.

Then you would try sqlserver, with creds and see...

Alternatively, you can do likewsie with sqlserver with creds on Admin Tools to keep it simple for troubleshooting (Only do this locally, if app is promoted to full blown app server jdbc/odbc datasource via Admin Tools will have unfriendly results) :-)

Post what you have for a closer look, the whole thing... catch blocks and all:-) look into your creds, you will need those, except of course if the admins near leave it all open for all to see:-)

C-ya!