These pages cover SQL Monitor 8, which is not the latest version. Help for other versions is also available.
Web server permissions
Published 08 March 2018
When using SQL Monitor web server
The web application retrieves data from the repository database populated by the base monitor service.
If using Windows Integrated Security, the windows identity provided to access the repository during installation will be used to run both the Website Service and the Base Monitor Service, so this user will be used to access the repository.
It is also necessary for this user to have permissions to read to %ProgramData%\Red Gate\SQL Monitor and %ProgramFiles%\Red Gate\SQL Monitor\Web (a quick solution for this is add the user to the local administrators group on the installation server)
Lastly, this user should be able to reserve a port mapping on the port specified in the installer (if this user is a local administrator, then this will just work, if not, you can run netsh http add urlacl url=http://*:<<port>>/ user=<<user>> as an administrator)
When using IIS Server
The web application retrieves data from the repository database populated by the base monitor service.
If you are using Windows Integrated Security to connect to the repository database, then it is necessary for the application pool identity of the SQL Monitor web application to have read access to the repository.