search cancel

UIM sqlserver probe Connection setup - difference between Windows authentication and SQL server authentication.

book

Article ID: 253029

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

We have a setup for monitoring AAG SQL servers.  The test results show that if the Connection is set for "SQL server authentication" we get AAG alerts.  However, if the Connection is set for "Windows authentication", we did not get any AAG alerts.  The DBA believes either way should have the same results.  Can you please let us know why the results are different?

Environment

Release: 20.3

Resolution

 sql_server.cfg the parameter-> "is_AlwaysOn" is blank, so just set it to "1"

  1. Open and edit sqlserver_monitor.cfg
  2. Search for "is_AlwaysOn"
  3. Update ("is_AlwaysOn = 1") with value 1 in all places.
  4. Restart the probe