check_dbalive alert is not getting cleared after I start the SQL services in the IM console.

Article Id: 35023
Status: Published
Updated On: 14-02-2018 07:40
Legacy Id: TEC000005171
Products:
CA Unified Infrastructure Management On-Premise (Nimsoft / UIM) NIMSOFT PROBES
Issue/Introduction:

Symptoms


Problem:
**********
check_dbalive alarm is not getting cleared.

Message in sqlserver.log:

Profile profile, Cannot connect to database instance sample_server: (Profile: profile/check_dbalive/Connect - COM Error: Code=0x80004005 Source=Microsoft OLE DB Provider for ODBC Drivers Description=[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
?





Solution


Solution:
**********
Please follow the steps below:
  1. Right click on the sqlserver probe configuration connection
  2. Double click on the connection and it will open the connection setup
  3. And set as per below:
Retry attempts -- 2
Retry delay -- 1 min
Timeout -- 30 Sec

??????? 4. Restart the sqlserver probe

The alarm will clear within 3 minutes after sqlserver services are UP.

Environment:

Release:
Component: UIMSQS