<![CDATA[Latest posts for the topic "Connecting to SQLServer 2000"]]> http://forums.visual-paradigm.com/posts/40.html JForum - http://www.jforum.net 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:

Code: 
 
 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()
]]> http://forums.visual-paradigm.com/posts/2041#16381.html http://forums.visual-paradigm.com/posts/2041#16381.html Re:Connecting to SQLServer 2000
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]]> http://forums.visual-paradigm.com/posts/2041#16382.html http://forums.visual-paradigm.com/posts/2041#16382.html Re:Connecting to SQLServer 2000 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]]> http://forums.visual-paradigm.com/posts/2041#16405.html http://forums.visual-paradigm.com/posts/2041#16405.html Re:Connecting to SQLServer 2000
You are welcome. Feel free to post again if there are any questions.

Best regards,
Jick]]> http://forums.visual-paradigm.com/posts/2041#16407.html http://forums.visual-paradigm.com/posts/2041#16407.html