Versions Compared

Old Version 33

changes.mady.by.user Wara Hermosa

Saved on

compared with

New Version 34

changes.mady.by.user Wara Hermosa

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

SQL Diagnostic Manager now includes a SQL script to create new user with minimum permissions necessary for the product to function.

  1. Use the Find/Replace function to locate and replace all references of 'SQLdmCollectionUser' with the SQL user that is to be 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 create the SQL user with the minimum permissions required to view the data on most of the screens of the application.
    Find the MinimumPermissionsOnPremises.sql script below:
    Attachments
    uploadfalse
    oldfalse
    patternsMinimumPermissionsOnPremises.sql
    sortByname
    pageUser Creation Scripts On Premises
  3. When registering the instance in SQL Diagnostic Manager, specify the SQL account that was created through the script so that SQL Diagnostic Manager connects to the monitored instance using the newly created account.

...