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

book

Article ID: 35023

calendar_today

Updated On:

Products

DX Infrastructure Management 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