lpar2rrd MS SQL monitoring: SQL server permissions

Elix

Dears,

the possibilities to monitor MS SQL Servers introduced in 7.30 is a really nice feature, thanks for that!

Upon documentation, it's required to create an SQL user account:

CREATE LOGIN lpar2rrd WITH PASSWORD = 'your_passw0rd'';
CREATE USER lpar2rrd FOR LOGIN lpar2rrd; 
GRANT VIEW SERVER STATE TO lpar2rrd;

Unfortunately, the connection test while adding a new server fails unless setting permissions on the database given in the server details. Even the connection test has been passed successful, no graphs are populated with values. I had to set 'Connect any database' on server level:

GRANT CONNECT ANY DATABASE TO lpar2rrd;

Is this the intended way?

Many thanks,
Elix

damerva

Hello Elix,

this is the intended. (we will add it to documentation, thank you for letting us know).
Some of the data would still be visible if users permission were just for the one DB you use in web UI form, but you would lose some metrics as the script tries to connect every DB that shows up in the results of querying this DMV "sys.dm_os_performance_counters" and then looks for additional data(Health status, relations, db size, etc.)

Elix

Thank you for taking care and your explanations!

BR,
Elix