SSL Encryption Error for DB Activities

Situation/Issue

Following error occurs while connecting to the Database activity and polling. 

Error: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SQL Server returned an incomplete response. The connection has been closed."

Cause

Due to Microsoft updates, user may experience connectivity issues to Database when using SSL / TLS to secure the connection. Microsoft has added two new ciphers to Windows, which use a different Key Algorithm. The minimum key length for allowed by these ciphers is 1024 characters. If the key length used by the trading partners is less than this, the SSL /TLS Handshake will fail.

The issue is only witnessed when using the older JDBC drivers below version 4.2. Other drivers works fine. This occurs on the previous versions of Adeptia Suite such as v6.2 SP1 or earlier.

Resolution

Upgrading Adeptia Suite to the latest version using JAVA 7 or JAVA 8 with updated SQL JDBC drivers in following sequence:-

· Sqljdbc41.jar requires a JRE of 7 and supports the JDBC 4.1 API

· Sqljdbc42.jar requires a JRE of 8 and supports the JDBC 4.2 API

If upgrade is not feasible then you need to follow the steps mentioned in the following Microsoft forum post:

https://blogs.msdn.microsoft.com/dataaccesstechnologies/2016/11/30/intermittent-jdbc-connectivity-issue-the-driver-could-not-establish-a-secure-connection-to-sql-server-by-using-secure-sockets-layer-ssl-encryption-error-sql-server-returned-an-incomplete-respons/