Error while connecting to MSSQL data source or repository

Symptoms

While connecting to the MSSQL repository connection or data source, the following message is displayed:
The following error has occurred while accessing database: DAL01013. Cannot create connection to server 'Unknown server' due to the following: The driver could not establish a secure connection to SQL server by using Secure Socket Layer (SSL) encryption. Error: "The server selected protocol version TLS10 is not accepted by client preferences [TSL12]".

Causes

The connection to the data source is not established as the driver is not able to establish a secure connection to the SQL Server by using Secure Socket Layer (SSL) encryption. This happens as the new JAVA update does not support TLS1 protocol and disables it for security enhancement.

Environment

QMF for Workstation

Resolving the problem

Remove the TLSv1 and TLSv1.1 protocols from the jdk.tls.disabledAlgorithms property by completing the following steps:
  1. Navigate to ..\QMF for Workstation\jre\lib\security\java.security .
  2. In java.security property file, locate the following property:

    jdk.tls.disabledAlgorithms=SSLv3,TLSv1, TLSv1.1, RC4, DES, MD5withRSA, DH keySize < 1024, DESede, \ EC keySize < 224, 3DES_EDE_CBC, anon, NULL, DES_CBC

  3. Remove TLSv1 and TLSv1.1 from the jdk.tls.disabledAlgorithms property. The changed property should look like:

    jdk.tls.disabledAlgorithms=SSLv3, RC4, DES, MD5withRSA, DH keySize < 1024, DESede, \ EC keySize < 224, 3DES_EDE_CBC, anon, NULL, DES_CBC

    Note: Overriding JAVA update changes and removing TLSv1 and TLSv1.1 from the jdk.tls.disabledAlgorithms property file might result in security breach. Instead of using this workaround, it is recommended that you upgrade the database TSL protocol to the latest version.