6 Replies Latest reply on Jun 16, 2015 6:20 AM by stevenj@sca-corp.com

    ColdFusion 10 error attempting to query MSSQL database (SSL)




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




      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)