soitoolbox utility fails to connect to SQLServer Instance
search cancel

soitoolbox utility fails to connect to SQLServer Instance


Article ID: 5380


Updated On:


CA Service Operations Insight (SOI)


soitoolbox --findDBInconsistencies -m <sqlserverName\instanceName> -u <dbuser> –p <dbpassword in plaintext>

fails with the following error message:


Started 18/01/2017 at 08:54:22
-> Initializing DB connection to [email protected]<sqlserverName\instanceName> (timeouts=20/30)... DONE
-> Checking DB schema version... DONE

-> Looking for orphan candidates... DONE, found 0
-> Looking for orphan CIs... DONE, found 0
-> Looking for Catalyst Inconsistencies... ERROR: ('Exception:', ProgrammingError('42000', '[42000] [Microsoft][ODBC SQL
Server Driver][SQL Server]Error converting data type nvarchar to varbinary. (8114) (SQLExecDirectW)'))


SOI 3.3 - 4.0 SP2all supported SQL Server versions


the soitoolbox command line option -m does not support SQL Server Instance


create a configuration file for the soitoolbox utility to connect to SQL Server Instance.


  • --credentials
    Specifies the location of the file containing the user names and passwords for all systems that run CA SOI components. This command is required when you operate a distributed CA SOI instance.
  • -x
    Creates a configuration file template if the file does not exist.

For example:

soitoolbox --credentials=soitoolbox.cfg


edit soitoolbox.cfg and update the SQL Server connection credentials.

For example:


2. specfiy credentials for SOI Database



Additional Information