Highlighted

CF2016 and SQL Server 2016 port encrytion connection

Explorer ,
Apr 11, 2018

Copy link to clipboard

Copied

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

Views

786

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

CF2016 and SQL Server 2016 port encrytion connection

Explorer ,
Apr 11, 2018

Copy link to clipboard

Copied

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

Views

787

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Apr 11, 2018 0
Adobe Community Professional ,
Apr 11, 2018

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Apr 11, 2018 0
Explorer ,
Apr 16, 2018

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Apr 16, 2018 0
Adobe Community Professional ,
Apr 16, 2018

Copy link to clipboard

Copied

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

Dave Watts, Fig Leaf Software

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Apr 16, 2018 0
Explorer ,
Apr 16, 2018

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Apr 16, 2018 0
Adobe Community Professional ,
Apr 16, 2018

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Apr 16, 2018 0
stansell LATEST
Community Beginner ,
Apr 16, 2018

Copy link to clipboard

Copied

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.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Apr 16, 2018 0