...
| Anchor |
|---|
| onpremisestwo |
|---|
| onpremisestwo |
|---|
|
Recommended permissions on premises
Also, it SQL Diagnostic Manager also includes a SQL Script script to create new user with minimum and permissions necessary permissions for the product to function. This script has additional permissions required for trace, xevent manipulation, mirror, and replication.
- Use the Find/Replace function to locate and replace all references to of 'SQLdmConsoleUserSQLdmCollectionUser' with the name of your SQLdm UserSQL user that is being used for monitoring the SQL Server instance.
- Connect to the SQL Server that is hosting your SQLdm Repository database and execute this script.
You can find this script under the name of RecommendedPermissionOnPremisesReplicationMirroring.sql in the following path:
C:\Program Files\Idera\Idera SQL diagnostic manager\User Creation Scriptsyou want to monitor with Admin user and run this script to assing the recommended permissions to the SQL user to view the data in most of the screens of the application.
Find the RecommendedPermissionsOnPremises.sql script below:
| Attachments |
|---|
| preview | false |
|---|
| upload | false |
|---|
| old | false |
|---|
| sortBy | name |
|---|
|