To create a new SQL Server user (with minimum permissions required to monitor), perform the following steps:
Create a new login for the Splunk AppDynamics SQL Server Database Collector, such as AppD_User, using SQL Server Management Studio (SSMS).
To map the new user to master and msdb databases, click master and msdb under Users mapped to this login.
User mapping to "master" and "msdb" are mandatory for monitoring. To view object information in the Object Browser screens, additional mapping to other databases is required.
After creating the login, grant the following privileges to the user by substituting AppD_User with the name you specified on the Login - New window:
use master
GRANT VIEW ANY DATABASE TO AppD_User;
GRANT VIEW ANY definition to AppD_User;
GRANT VIEW server state to AppD_User;
GRANT SELECT ON [sys].[master_files] TO AppD_User;
