SQL Server probe connection alert

Document ID : KB000097313
Last Modified Date : 22/05/2018
Show Technical Document Details
sqlserver probe throws connection alarm though the test connection is successful.

Alert: Profile SQL_SERV_INST_NAME, Cannot connect to database instance SQL_SERV_INST_NAME: (n/a).

User-added image
UIM: 8.5.1
sqlserver: any version
This can happen when unit key value set to "days" in sqlserver probe checkpoints options.
Please follow below instructions to resolve the issue.

1. Open the sqlserver probe in Raw configure.
2. expand checkpoints and check_dbalive and thresholds and then go to 'default'.
3. Click on '0' and you will be able to see the options in right window.
4. Double click on "unit" key and remove the value "days"
                 User-added image
5. Click on Apply and then click on cancel button
6. Verify the issue.
Additional Information:
sqlserver probe documentation:

What queries are used by the CA UIM sqlserver probe?
CA UIM sqlserver probe is not sending alarms for the check_dbalive checkpoint.

How to create a new (custom) checkpoint using the sqlserver probe