CA WA DE loses connection to MS-SQL with Exception: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption

Document ID : KB000111644
Last Modified Date : 28/08/2018
Show Technical Document Details
Issue:
CA Workload Automation DE keeps loosing connection to the database.  The following messages are see in the tracelogs
 
[relationaldatabase] [ERROR] SS.script_runner_179: [] Exception: 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. ClientConnectionId:xxxxxa37-05d6-4f67-b606-xxxxxxxxxxxx". 
com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection 
to SQL Server by using Secure Sockets Layer (SSL) encryption.


 
Environment:
CA Workload Automation DE R12
MS-SQL Database 2016
Cause:
The connection issue is due to JDBC driver.  For more details refer to this Microsoft link.
Note:  The JDBC driver is maintained and provided by the database vendor.
Resolution:
Upgrade CA Workload Automation DE to R12 SP2 or above.
The R12 SP2 comes with JDBC 4.2 version.
Additional Information:
If the the problem persists, then follow Option 2 as suggested by Microsoft in this link.