ColdFusion 10 error attempting to query MSSQL database (SSL)

Question

Hello,Thanks for taking a look and for any ideas you might have.RobColdFusion app errors when attempting to query MSSQL 2008 R2 databse via SSL connection.The datasource verifies fine.   I have EncryptionMethod=SSL;validateServerCertificate=false for connection string.Setting a trace on the SQL server doesn't show it trying to hit the database at all.I have a copy of the same database on a SQL Server 2012 box (this one is server core if it matters).   I can edit the datasource to just point to this server and the app works fine.Both SQL servers require SSL.Here is the first few lines of a coldfusion log of database calls.spy(Thread-66)(2014/07/15 16:07:53.353)>> Connection[1].getMetaData()spy(Thread-66)(2014/07/15 16:07:53.353)>> java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Object has been closed. ErrorCode=0 SQLState=HY000java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Object has been closed.  at macromedia.jdbc.sqlserverbase.ddca.b(Unknown Source)  at macromedia.jdbc.sqlserverbase.ddca.a(Unknown Source)  at macromedia.jdbc.sqlserverbase.ddb9.b(Unknown Source)  at macromedia.jdbc.sqlserverbase.ddb9.a(Unknown Source)

norrisrg · Accepted Answer

I figured my problem out today, hope it helps with yours.

See this link.

http://support.microsoft.com/kb/2653857

I installed an old JRE (6 update 27) and it fixed the problem.

We are catching the patches up on our server tonight.

Rob

stevenj1 · Answer

I am having the same problem connecting to the same type of sql server. I thought it was because the connection string had to be more detailed.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.