Connecting to SQLServer 2000


Sorry to post on this topic, seem that a few people already have. I have read through their posts, to no avail.

I have tried many combinations of authentication and databases, even changed the sa password to something so simple I couldn’t misspell it.

I have attached a screen shot of my connection properties.

I can connect using other (MS) programs (Visio, Visual Studio)

The error I’m getting is:

Test adapter connection failed!
java.sql.SQLException: Network error IOException: Connection refused: connect
	at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(
	at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(
	at net.sourceforge.jtds.jdbc.Driver.connect(
	at org.orm.ertodb.DriverWrapper.connect(
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at v.igvh.i(:34)
	at v.igvh.f(:43)
Caused by: Connection refused: connect
	at Method)
	at Source)
	at Source)
	at Source)
	at Source)
	at Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(
	at net.sourceforge.jtds.jdbc.SharedSocket.<init>(
	at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(
	... 8 more
Test .NET connection failed!
java.lang.Exception: SQL Server does not exist or access denied.
   at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
   at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
   at System.Data.SqlClient.SqlConnection.Open()
   at NHibernate.Connection.DriverConnectionProvider.GetConnection()
``` <br><img src='/uploads/default/original/1X/badb2fee0157609d59bc17199f50abb5d2d5e134.png' width='607' height='500'/></br>db-connection.png <br><img src='/uploads/default/original/1X/9fd578b39c287b1292a0420e87ee08f051adbadd.png' width='276' height='500'/></br>db-connection(VS).png

Hello Quinten,

Thank you for your post. I think that you haven’t enable to SQL Serer to accept connection from external application (maybe some TCP/IP or firewall settings). Please try to enable those settings in your server and see if it help. Thanks in advance!

Best regards,

Firstly, thanks for the speedy reply.
Secondly, thanks for such a great product (just need to save up for the suite)

For the life of me I couldn’t get SQL Server 2000 to work (normally I would use MySQL)

In the end I installed SQL 2005 Express, changed the settings to allow external connections and all was good.

Thanks for your help

Hello Quinten,

You are welcome. Feel free to post again if there are any questions.

Best regards,