Skip to main content
Inspiring
April 11, 2018
Question

CF2016 and SQL Server 2016 port encrytion connection

  • April 11, 2018
  • 1 reply
  • 1636 views

Hi,

Currently standing up ColdFusion 2016 and SQL Server 2016.

In the Cold Fusion Admin, added the following in the Connection String (came from the CF11 encryption)

EncryptionMethod=SSL; ValidateServerCertificate=false;

Port 1433 has a certificate installed.

Below is the certificate information:

Version: V3

Signature Algorithm: sha256RSa

Signature hash algorithm: sha256

Thumbprint algorithm: sha 1

The following error message appears when trying to check the connection between the ColdFusion2016 and the SQL Server database.

java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]SSL handshake failed: Unsupported curveId: 29

The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]SSL handshake failed: Unsupported curveId: 29

Thanks,

Mike

    This topic has been closed for replies.

    1 reply

    Community Expert
    April 11, 2018

    The first thing I'd do is try upgrading the ColdFusion JVM to the absolute latest version. Beyond that, it looks like it may be fairly difficult to solve this.

    Dave Watts, Fig Leaf Software

    Dave Watts, Eidolon LLC
    userCold9Author
    Inspiring
    April 16, 2018

    Hi,

    I found the following thread: https://forums.adobe.com/thread/2382761
    (CF2016 JDBC SQL Server 2016 SSL Connections work around)

    It looks like this is for Linux.

    We installed Cold Fusion 2016 on windows.

    Would the solution in the thread be the same for windows?

    Thanks,

    Mike

    Community Expert
    April 16, 2018

    Basically, yes. Those drivers will work on Windows or Linux.

    Dave Watts, Fig Leaf Software

    Dave Watts, Eidolon LLC