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:
- Right click on the sqlserver probe configuration connection
- Double click on the connection and it will open the connection setup
- 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.