MS SQL Monitoring Permissions

[mlev]

I want to setup SQL Server monitoring in Nagios XI via the MSSQL Monitoring Wizard and I was wondering what permissions the SQL account that I enter (the username) should have in order to successfully monitor each of the services? I have tried when using an account with limited access to the databases on the server and it has not worked.

[slansing]

What type of limited access are we talking? The account should have access to view all of the table/DB metrics listed in the wizard, or else you might run into a few which you can't check. You could run through the wizard, and then have the account's permissions changed to test if they work, that way you don't have to do double the work.

[MSPk]

Hi mlev,

You would need a dbuser with sql quthentication created on each DB instance, set the "server role" permission to "public" and "user mapping" permission to "all databases in the instance dbreader permission" and also the user should have access to Sysperfinfo table. This should work for all the parameters.

[abrist]

That should do it for the basic checks, though if you have some dbs locked down further that you wish to run queries against, you may need to muss about with the privileges a bit more.