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.

You can see the permissions that DPA uses here:

• See SQL Server Permissions required for DPA for a full list of permissions required for DPA to monitor an SQL Server database. 
• Registering SQL Server without the SysAdmin Password (12.0, 12.1)

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.

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