Coldfusion 2021 MSSQL SSL socket connection error

Forum|Forum|3 years ago
June 18, 2022
1 reply
543 views

I am getting this issue on Coldfusion 2021.

JDK 12.0.2 is used.

Azure MSSQL Server is used.

Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver]An SSL socket connection could not be established because JRE 1.4 or above is required.

Can anyone help me?

Thanks!

This topic has been closed for replies.

BKBK

Community Expert

Why use JDK 12 on ColdFusion? That may or may not be relevant to the SSL socket issue. However, the recommended version to use is JDK 11, the latest version of which you can download from the ColdFusion Downloads page.

Someone else reported the same SSL socket issue in this very forum. And they found a solution!

It may be worth your while to follow the recommendations in the thread: https://community.adobe.com/t5/coldfusion-discussions/coldfusion-2021-data-source-an-ssl-socket-conn...

S

Souvik Saha ChoudhuryAuthor

Known Participant

I checked the thread.
My Connection String is EncryptionMethod=SSL;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;hostNameInCertificate=*.database.windows.net;Connection Timeout=30;

Do I need to import certificate?

Thanks,Souvik

Vikram Kumar M

Community Manager

Hi Souvik,

Could you please try the below connection string?

EncryptionMethod=SSL;CryptoProtocolVersion=TLSv1.2;ValidateServerCertificate=false

If you continue to encounter the error, please get in touch with us at cf.install@adobe.com.

Thanks,

Vikram

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded