MS SQL Server 2005 error

[mkha98]

I am having trouble connecting to my SQL Server 2005 from my mac using SQLGrinder. From a PC and MS SQL Express Edition, I am able to connect; from OS X and SQL Grinder I get the following error messag:

I/O Error: DB server closed connection.

Thoughts?
Mayur

[michaeldupuis]

Hard to tell from just that. Do you have to full error message from the SQLGrinder message log? Thanks.

[mkha98]

Thank you for your follow - up.
Using jTDS, I get

java.sql.SQLException: I/O Error: DB server closed connection.
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2277)
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:599)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:331)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.advenio.jdbclib.threads.ConnectionThread.threadRunLogic(Unknown Source)
at com.advenio.jdbclib.threads.AbstractThread.run(Unknown Source)
Caused by: java.io.IOException: DB server closed connection.
at net.sourceforge.jtds.jdbc.SharedSocket.readPacket(SharedSocket.java:828)
at net.sourceforge.jtds.jdbc.SharedSocket.getNetPacket(SharedSocket.java:707)
at net.sourceforge.jtds.jdbc.ResponseStream.getPacket(ResponseStream.java:466)
at net.sourceforge.jtds.jdbc.ResponseStream.read(ResponseStream.java:103)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2172)
... 8 more


Using MS SQL Server 2005, I get

com.microsoft.sqlserver.jdbc.SQLServerException: The SQL Server login requires an SSL connection.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.DBComms.Prelogin(Unknown Source)
at com.microsoft.sqlserver.jdbc.DBComms.<init>(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.advenio.jdbclib.threads.ConnectionThread.threadRunLogic(Unknown Source)
at com.advenio.jdbclib.threads.AbstractThread.run(Unknown Source)

Any thougths?

[michaeldupuis]

I think the SQL Server 2005 driver error pretty much says what the problem is: "The SQL Server login requires an SSL connection." The server must be requiring that. Off the top of my head I'm not sure how to make that work with JDBC.

[mkha98]

What I should have mentioned was that my hosting service says that don't require SSL.

Any other thoughts? Takers?

Thanks,
Mayur

[tcarroll]

i am running into the same problem. has anyone identified a fix or work around for this yet?

thanks, tim