Coldfusion 2021 MSSQL SSL socket connection error

[Souvik Saha Choudhury]

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!

[BKBK]

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... 

[Souvik Saha Choudhury]

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?

[Vikram Kumar M]

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

[Souvik Saha Choudhury]

Hi Vikram,

I only added ValidateServerCertificate=false with my existing connection string and it worked.

Is it safe to disable validation?