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

Products

• DX Infrastructure Management
• NIMSOFT PROBES

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.