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', ' [Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error (18) (SQLDriverConnect);
 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (SECDoClientHandshake()). (772)')
-> Initializing DB connection to SAMStore@XXXXXXXX: (timeouts=600/28800).
Release : 4.2
Component : Service Operations Insight (SOI) Manager
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.
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.