CF2016 and SQL Server 2016 port encrytion connection

[userCold9]

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

[Dave Watts]

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

[userCold9]

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

[Dave Watts]

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

Dave Watts, Fig Leaf Software

[userCold9]

Hi,

The CF2016 JDBC SQL Server 2016 SSL Connections work around post has the following for Linux.

Since the will be installed on Windows, what are the commands for windows and steps for windows?

Step 2. tar -xvf sqljdbc_6.2.1.0_enu.tar.gz

Step 3. sudo cp sqljdbc_6.2/enu/mssql-jdbc-6.2.1.jre8.jar /opt/coldfusion2016/cfusion/lib/

Thanks,

Mike

[Dave Watts]

Go here and download the Microsoft SQL Server driver, and read the platform-specific instructions for Windows.

Download Microsoft JDBC Driver 6.0 for SQL Server from Official Microsoft Download Center

Dave Watts, Fig Leaf Software

[stansell]

Step 2. tar -xvf sqljdbc_6.2.1.0_enu.tar.gz 
This is a command to "unzip" the .gz file.  In Windows you can probably use a program like WinZip or PowerArchiver to unzip the .gz file.

Step 3. sudo cp sqljdbc_6.2/enu/mssql-jdbc-6.2.1.jre8.jar /opt/coldfusion2016/cfusion/lib/
This is a copy command - in windows, just copy the mssql-jdbc-6.2.1.jre8.jar file (extracted from the .gz file) to the /opt/coldfusion2016/cfusion/lib/ directory.