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.
You can see the permissions that DPA uses here:
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.
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.
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.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.