SOIToolBox can't connect to the Database

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

When running the SOIToolBox utility, getting the following error

Exception while connecting using SQL Server driver : ('08001', '[08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. (17) (SQLDriverConnect); [01000] [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). (53)')

Environment

Release : 4.2

Component : Service Operations Insight (SOI) Manager

Resolution

The error was a result of an incorrect entry in the soitoolbox.cfg file.

The line database=<databaseName>;<machineName>;<instance>;<port>;<userName>;<PlainTextPassword> didn't have the correct hostname of the SQL Server.

 

Once we corrected the hostname, the SOIToolbox was able to connect to the Database.