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

Products

• NIMSOFT PROBES
• CA Unified Infrastructure Management for z Systems
• DX Infrastructure Management

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

Cause

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

Environment

UIM Server:  Any version
sqlserver probe:  any version

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://docops.ca.com/ca-unified-infrastructure-management-probes/ga/en/alphabetical-probe-articles/sqlserver-sql-server-monitoring/sqlserver-im-configuration#sqlserverIMConfiguration-ConfiguretheProbe