ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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 [email protected]:1433 (timeouts=20/30)... -> Initializing DB connection to [email protected]: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)'))


ODBC driver not compatible with SQL 2016


Release : 4.2

Component : Service Operations Insight (SOI) Manager


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.