Page History

SQL Diagnostic Manager allows you to monitor SQL Server instances without SysAdmin rights. However, these lowered permissions limit the availability of data.

The user creation scripts are detailed, as follows:

• Recommended permissions for Azure
• Recommended permissions for Azure replication mirroring
• Minimum permissions on premises
• Recommended permissions on premises

Anchor
azureone azureone

Recommended permissions for Azure

SQL Diagnostic Manager now includes a SQL Script to create a new user for Azure SQL Database Standard and Basic Tier with the minimum and necessary permissions for the product to function. Also, includes additional permissions that are required for trace and xevent manipulation.

1. Use the Find/Replace function to locate and replace all references to 'SQLdmConsoleUser' with the name of your SQLdm User.
2. 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 Script

Anchor
azuretwo azuretwo

Recommended permissions for Azure replication mirroring

Also, it includes a SQL Script to create new user for Azure SQL Database Standard and Basic Tier with minimum and necessary permissions for the product to function. This script has additional permissions required for trace, xevent manipulation, mirror, and replication.

1. Use the Find/Replace function to locate and replace all references to 'SQLdmConsoleUser' with the name of your SQLdm User.
2. 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 RecommendedPermissionsAzureReplicationMirroring.sql in the following path:
     C:\Program Files\Idera\Idera SQL diagnostic manager\User Creation Scripts

Anchor
onpremisesone onpremisesone

Minimum permissions on premises

...

1. Use the Find/Replace function to locate and replace all references of 'SQLdmCollectionUser' with the SQL user that is being used for monitoring the SQL Server instance.
2. Connect to the SQL Server that you want to monitor with Admin user and run this script to assign the minimum permissions to the SQL user to view the data in most of the screens of the application.
   Find the MinimumPermissionsOnPremises.sql script below:
   

   Attachments
   preview false upload false old false patterns MinimumPermissionsOnPremises.sql sortBy name page User creation scripts

...

1. Use the Find/Replace function to locate and replace all references of 'SQLdmCollectionUser' with the SQL user that is being used for monitoring the SQL Server instance.
2. Connect to the SQL Server that you want to monitor with Admin user and run this script to assign 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:

...

...