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

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 Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

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

UIM 20.1 & Later

SqlServer 5.45

Resolution

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.