Page History

...

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.
   

   Attachments
   upload false

SQL Diagnostic Manager now includes a SQL Script to create a new user with the minimum and necessary permissions for the product to function. Additionally, it includes 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.Connect to the SQL Server that is hosting your SQLdm Repository database and execute the script found under the name of RecommendedPermissionsOnPremises.sql in the following path:
     C:\Program Files\Idera\Idera SQL diagnostic manager\User Creation Scriptsthe MinimumPermissionsOnPremises.sql script below:
   Image Added

Anchor
onpremisestwo onpremisestwo

Recommended permissions on premises

...