SQL Server probe connection alert

Document ID : KB000097313
Last Modified Date : 22/05/2018
Show Technical Document Details
Issue:
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
Environment:
UIM: 8.5.1
sqlserver: any version
Cause:
This can happen when unit key value set to "days" in sqlserver probe checkpoints options.
Resolution:
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:
https://docops.ca.com/ca-unified-infrastructure-management-probes/ga/en/alphabetical-probe-articles/sqlserver-sql-server-monitoring/sqlserver-sql-server-monitoring-release-notes

What queries are used by the CA UIM sqlserver probe?
http://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.tec000003088.html
CA UIM sqlserver probe is not sending alarms for the check_dbalive checkpoint.
https://comm.support.ca.com/kb/ca-uim-sqlserver-probe-is-not-sending-alarms-for-the-checkdbalive-checkpoint/kb000036501

How to create a new (custom) checkpoint using the sqlserver probe
https://comm.support.ca.com/kb/how-to-create-a-new-custom-checkpoint-using-the-sqlserver-probe/kb000039422