Setup SQL Management Pack with a single account

  • Article

Hi,

A few weeks ago I was with a customer giving them guidance on how to setup the management pack for SQL, and the three accounts required where a problem for them, they told me it was to complicated because of how their account management process works.

This is a common request among customers so I thought it was a good idea to share this configuration with the community, so here are the permissions required to use a single account scenario for the SQL management pack Run As Accounts.

 

  1. Add user to the following local security groups>
    1. Perfomance Monitor Users
    2. Event Log Readers
    3. Users
  2. In SQL Server Management Studio grant the following privileges to the user:
    1. VIEW ANY DEFINITION
    2. VIEW SERVER STATE
    3. VIEW ANY DATABASE
  3. Map the user login to the msdb database and any other you want to monitor.
  4. Add the user login to the msdb database with the SQLAgentReaderRole.
  5. Add the user login to the msdb database with the PolicyAdministratorRole.
  6. Restart the healthservice.exe on the SQL Server.

Hope this helps with your SQL management pack setup.