ColdFusion 10 error attempting to query MSSQL database (SSL)

Hello,

Thanks for taking a look and for any ideas you might have.

Rob

ColdFusion 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=HY000

java.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)