SOIToolBox and encrypted SQL Server connections

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

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

Environment

Release : 4.2

Component : Service Operations Insight (SOI) Manager

Cause

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.

 

Resolution

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