Page History
...
- 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.
- 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 previewupload false uploadold false oldpatterns falseMinimumPermissionsOnPremises.sql sortBy name page User creation scripts
...
- 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.
- Connect to the SQL Server that you 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 patterns RecommendedPermissionsOnPremises.sql sortBy name page User creation scripts
Scroll pdf ignore |
---|
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > > |