SOIToolbox utility does not work with SQL 2016

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

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)'))

Environment

Release: 4.2

Component: Service Operations Insight (SOI) Manager

Cause

• ODBC driver not compatible with SQL 2016

Resolution

Using SQL 2016 without encrypted SQL Server connections.

2 things are needed to resolve issue.

1) Apply SOI patch SO15850

https://support.broadcom.com/external/content/release-announcements/CA-Service-Operations-Insight-Solutions--Patches/6500

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.