...
- Use the Find/Replace function to locate and replace all references to 'SQLdmConsoleUser' with the name of your SQLdm User.
- Connect to the SQL Server that is hosting your SQLdm Repository database and execute the script found under the name of RecommendedPermissionsAzure.sql in the following path:
C:\Program Files\Idera\Idera SQL diagnostic manager\User Creation Scripts
| Sectionexpand |
|---|
| title | Recommended Permissions for Azure | border | true |
|---|
|
| View file |
|---|
| View file |
|---|
| name | RecommendedPermissionsAzure.sql |
|---|
| height | 250 |
|---|
|
| View file |
|---|
| name | RecommendedPermissionsOnPremisesReplicationMirroring.sql |
|---|
| height | 250 |
|---|
|
| View file |
|---|
| name | RecommendedPermissionsOnPremises.sql |
|---|
| height | 250 |
|---|
|
| name | RecommendedPermissionsAzureReplicationMirroring.sql |
|---|
| height | 250 |
|---|
|
|
Recommended permissions for Azure replication mirroring
...