Skip to main content
Souvik Saha Choudhury
Known Participant
Jun 18, 2022 9:11 AM UTC
Question

Coldfusion 2021 MSSQL SSL socket connection error

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 is closed to new replies. Start a new post to keep the conversation going.

    4 replies

    BKBK
    Community Expert
    BKBKCommunity Expert
    Community Expert
    Jun 21, 2022 10:46 AM UTC

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

    Translate
      Souvik Saha ChoudhuryAuthor
      Known Participant
      Jun 23, 2022 11:43 AM UTC

      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?

      Translate
      Thanks,Souvik
      Vikram Kumar M
      Vikram Kumar M
      Inspiring
      Jun 23, 2022 3:57 PM UTC

      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

       

      Translate
        Terms & ConditionsAccessibility statement
        Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices