Connecting to SQLServer 2000

General Questions/Discussions
1

Howdy

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>(ConnectionJDBC2.java:372)
	at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
	at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178)
	at org.orm.ertodb.DriverWrapper.connect(DriverWrapper.java:27)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at v.igvh.i(:34)
	at v.igvh.f(:43)
	at v.ame.run(:21)
Caused by: java.net.ConnectException: Connection refused: connect
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at java.net.PlainSocketImpl.doConnect(Unknown Source)
	at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
	at java.net.PlainSocketImpl.connect(Unknown Source)
	at java.net.SocksSocketImpl.connect(Unknown Source)
	at java.net.Socket.connect(Unknown 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(SharedSocket.java:289)
	at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:250)
	at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:297)
	... 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
2

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,
Jick

3

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

4

Hello Quinten,

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

Best regards,
Jick