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 create the SQL user with the minimum permissions required to the SQL user to view the data in on most of the screens of the application.
Find the MinimumPermissionsOnPremises.sql script below:Attachments upload false old false patterns MinimumPermissionsOnPremises.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 assign create the SQL user with the recommended permissions to the SQL user to view the data in on 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
...