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
• Using SQL 2016 without encrypted SQL Server connections.

Resolution

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 that the soitoolbox utility will use the default ODBC driver first, if that fails, it will use the new driver.