SOIToolBox and encrypted SQL Server connections
search cancel

SOIToolBox and encrypted SQL Server connections


Article ID: 206695


Updated On:


CA Service Operations Insight (SOI)


Having some issue using the soitoolbox to execute sql database functions. Recently applied the patch for SQL DB forced encryption, SO15850.

Getting the following error

soitoolbox.exe -x -b 600 -t 28800 --findDBInconsistencies
Started 04/01/2021 at 16:05:58
-> Parsing configuration file soitoolbox.cfg ... Done, 58 lines processed
-> Initializing DB connection to SAMStore@XXXXXXXXX: (timeouts=600/28800).
Connecting using SQL Server driver

Exception while connecting using SQL Server driver : ('08001', '[08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error (18) (SQLDriverConnect);
[01000] [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (SECDoClientHandshake()). (772)')
-> Initializing DB connection to SAMStore@XXXXXXXX: (timeouts=600/28800).


Release : 4.2

Component : Service Operations Insight (SOI) Manager


SOIToolBox utility use the ODBC driver from the server.

In the ODBC Data Sources, it only contain the old default SQL Driver 6.03.9600.17415 dated 10/28/2014

This old driver doesn't support encrypted SQL Server connections.



Install a later version of the ODBC Driver.

The soitoolbox command will use the old driver, once that didn't work the soitoolbox automatically switch to the new driver and will be able to connect to the Database.

Additional Information