SOIToolbox utility does not work with SQL 2016
search cancel

SOIToolbox utility does not work with SQL 2016


Article ID: 208325


Updated On:


CA Service Operations Insight (SOI)


SOIToolbox utility is returning the following error

D:\CA\SOI\Tools>soitoolbox.exe -x --getStatisticalData

Started 26/01/2021 at 15:06:40

-> Parsing configuration file soitoolbox.cfg ... Done, 64 lines processed

-> Initializing DB connection to SAMStore@xxxx:1433 (timeouts=20/30)... -> Initializing DB connection to SAMStore@xxxx:1433 (timeouts=20/30)...

-> Going to access 'SAMStore' database on machine 'xxxx'

   Provide password for user 'user':

 -> Initializing DB connection to [email protected]:5533 (timeouts=20/30)... ERROR: ('Exception:', Error('08001', '[08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error (18) (SQLDriverConnect); [01000] [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (SECDoClientHandshake()). (817)'))


Release: 4.2

Component: Service Operations Insight (SOI) Manager


  • ODBC driver not compatible with SQL 2016


Using SQL 2016 without encrypted SQL Server connections.

2 things are needed to resolve issue.

1) Apply SOI patch SO15850

If you don't have this patch, the SOIToolbox utility will not use additional ODBC driver.

2) Install the latest ODBC driver from Microsoft on the SOI Manager server where soitoolbox.exe is being executed from.

Additional Information

The result is the soitoolbox utility will use the default ODBC driver first, when that failed, it will use the new driver.