SQL Server probe connection alert

book

Article ID: 97313

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

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).

Cause

This can happen when unit key value set to any value (like "days", "hours", etc) in sqlserver probe checkpoints options.

Environment

UIM: 8.5.1
sqlserver: any version

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" in this example

               

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?
https://comm.support.ca.com/kb/sql-server-probe-connection-alert/kb000097313
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

Attachments