The Add Permission wizard allows you to give SQL Diagnostic Manager access to a specified login in your environment. By default, all users belonging to the sysadmin role on the SQL Diagnostic Manager Repository have SQL Diagnostic Manager Administrator privileges and all other users are denied access to any of the monitoring and diagnostic views in SQL Diagnostic Manager.
Logins belonging to the sysadmin role on the SQL Diagnostic Manager Repository have SQL Diagnostic Manager Administrator privileges and you cannot edit or delete these accounts. |
Each login account can have multiple permissions associated with it. For example, if you want User A to have the ability to view all your SQL Server instances but modify only one of them, you can create two permissions. Include View permissions in the first login to allow the login to view all your SQL Server instances, and enable Modify permissions for the specified SQL Server instance in the second login.
If a SQL login is entered and it does not already exist, a new login account is created on the SQL Diagnostic Manager Repository SQL Server instance. |
To create a SQLDM login account:
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
|