sqlserver probe throws connection alarm though the test connection is successful.

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• Unified Infrastructure Management for Mainframe

Issue/Introduction

sqlserver probe connection profile test works fine, but the probe continues to generate connection alarms for the checkdb_alive checkpoint even after following instructions in the following Knowledge Document:

KB97313 : SQL Server probe connection alert

Environment

UIM Server:  Any version
sqlserver probe:  any version

Cause

The Connection field in the sqlserver monitoring profile was configured to use an non-existent connection profile.

Resolution

Change the Connection field in the sqlserver monitoring profile to use the tested connection profile name.

Additional Information

See step #2 om the "Create a Profile" subsection found ound the "Configure the Probe" section of the "sqlserver IM Configuration" Wiki document:

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/ca-unified-infrastructure-management-probes/GA/alphabetical-probe-articles/sqlserver-sql-server-monitoring/sqlserver-im-configuration.html#concept.dita_6418cedd176b65bd76d08c07a34b8d59f840ad8f_ConfiguretheProbe