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."
JTDS is not compatible with SQL configured with SSL/Forced encryption.
Release : 4.2
Component : Service Operations Insight (SOI) Manager
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.