lpar2rrd MS SQL monitoring: SQL server permissions

Elix
Elix
in LPAR2RRD
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

Comments

  • damerva
    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
    Elix
    Thank you for taking care and your explanations!

    BR,
    Elix

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Register

Categories

In this Discussion