cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 9

SQL Monitoring

Our database team is very reluctant to provide the sysadmin credentials for the database servers. Is there any way that we can monitor the database servers without the provision of sysadmin credentials. Like in SAM, a SQL server can be monitored to some extent using a limited rights user.

I have tried DPA and SQL Sentry One, but both need SYSADMIN credentials.

Kindly tell me the way around for it.

0 Kudos
5 Replies
Highlighted

Re: SQL Monitoring

DPA only uses the SA credential once, when you first add the database server.  At that time it creates a local service account that has minimal permissions.  Have them give you a temporary SA account and they can delete it when you are done.

- Marc Netterfield, Github
0 Kudos
Highlighted
Product Manager
Product Manager

Re: SQL Monitoring

You can see the permissions that DPA uses here:

0 Kudos
Highlighted

Re: SQL Monitoring

Should note these only are documented to apply up to DPA 9.2 (quite an old version).  Most recent is 2019.4.  Should ask SolarWinds if these permissions are up-to-date.

0 Kudos
Highlighted
Product Manager
Product Manager

Re: SQL Monitoring

Hi.  If you look at the environment list section, you'll see it goes through 12.1, which is the release prior to 2019.4.  These should be still applicable to 2019.4, I've asked to get the documents updated, and see if we can list the newest version first.   Cheers.

0 Kudos
Highlighted

Re: SQL Monitoring

oops, I caught the last section and assumed it was the last version... need coffee...

0 Kudos