SQL Monitoring user

[murben]

Is there any documentation on the SQL permissions required for the user in the SQL plugin?  It seems that if we assign anything less than sysadmin privileges, the plugin will not connect and monitor the DB.

[admin]

Hi,

Latest MSSQL plugin includes new metrics to make plugin be more usable for a customer. Those metrics are required credentials for connection to  MSSQL instance to receive the data from system tables. For that we need a relevant permissions.

[murben]

I understand there are permissions that are required, but do you have a list of exactly what permissions are required? 

[admin · Accepted solution]

You need to add

GRANT VIEW ANY DEFINITION to [user]

It should be work without sysadmin role. I created "test1" user and it was worked for me:

USE [master]

GO

CREATE LOGIN [test1]

WITH PASSWORD=N'test1',

DEFAULT_DATABASE=[master],

DEFAULT_LANGUAGE=[us_english],

CHECK_EXPIRATION=OFF,

CHECK_POLICY=OFF

GO

GRANT VIEW ANY DEFINITION to test1

GO

[murben]

That did the trick!  Thanks! 

Is there any reason this isn't included in the documentation for the plugin?

[admin]

Great feedback. We'll update it.

Thanks.