JDBC - connect timed out to SQL Server 2000

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

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.

re: JDBC - connect timed out to SQL Server 2000

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:

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!