Type
  • Best practice
Description
  • This article explains how to configure Microsoft SQL Database Monitors using Windows integrated authentication, with Monitoring Studio 9.4.xx
Additional Keywords
  • Monitoring Studio KM for PATROL 9.4.xx, Database, SQL, JDBC, Windows
Knowledge Base

Monitoring Microsoft SQL Server with Monitoring Studio 9.4.xx

KB1251 - May 22, 2019

Introduction

This article explains how to configure Microsoft SQL Database Monitors using Windows-integrated Authentication, with Monitoring Studio 9.4.xx.

SQL Server Authentication is handled automatically by Microsoft's JDBC driver. When using Windows-integrated Authentication, the connection will be done using the PATROL Agent's default account. No credentials should therefore be set in the policy for the device.

Prerequisites

  • The account must have permissions to access the Microsoft SQL database.
  • The Windows account being used must be part of the Local Administrators group on the PATROL Agent system.
  • The account must be specified as the "Default Account" for the PATROL Agent.

Setting the Default Credentials for the PATROL Agent

As credentials must not be specified in the policy, the query will be executed by the PATROL Agent's default credentials. These are set through a configuration parameter on the Agent.

The parameter to set is /agentSetup/defaultAccount. A valid username and password must be specified.

This parameter can be set through the policy, or by other tools such as wpconfig. For more information about the wpconfig utility, refer to the BMC Documentation.

Configuring the Policy

  1. Within a TrueSight Infrastructure Policy, add or edit a monitoring configuration for Monitoring Studio.

    Monitoring Configuration

  2. Within the Monitor Groups, add or edit a Monitor Group for the system on which the query will be run.

    Monitor Groups

  3. In the Monitor Group Information, specify the Hostname, Internal ID, and Display Name and leave the system credentials blank.

    Monitor Group Information

  4. Under the Microsoft SQL Server section of Monitors, specify the query, and related parameters.

    Database Query Information

  5. Specify the port, and set the authentication mode to "Windows". Leave the Username and Password fields blank.

    SQL Server Settings