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

Products

• DSERIES- SERVER
• CA Workload Automation DE - System Agent (dSeries)

Issue/Introduction

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.