SOI DB connection through SSL

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

Database team has enabled SQL Db to use SSL "Force encryption"  and now SOI is unable to connect to the DB, it shows error following error in soimgr-debug.log

"Caused by: java.sql.SQLException: I/O Error: DB server closed connection"

The SQL log shows the following error

"Encryption is required to connect to this server but the client library does not support encryption; the connection has been closed. Please upgrade your client library."

 

 

Cause

JTDS is not compatible with SQL configured with SSL/Forced encryption.

Environment

Release : 4.2

Component : Service Operations Insight (SOI) Manager

Resolution

SOI by design uses JTDS for SQL connection and JTDS is not compatible with SQL configured with SSL/Forced encryption. To make the SOI compatible with SQL configured with SSL/Forced encryption would require us to re-architect SOI to use MS JDBC instead of JTDS.
Since this is working as designed you'll have to create an IDEA in "DX Operational Intelligence" community.