The Web Server isn't authorized to access this Base Monitor
Published 07 October 2020
SQL Monitor displays this error when you try to connect from a Web Server that the Base Monitor doesn't recognize.
To fix the problem, pair the Base Monitor with the new Web Server.
If you want to switch over from an old Web Server to a new one:
Once you pair the Base Monitor to a new Web Server, you won't be able to connect using the old Web Server.
- On the machine running the Base Monitor, go to %ProgramData%\Red Gate\SQL Monitor\
- Delete RedGate.SqlMonitor.AuthorizedClients.config
- On the Web Server you want to use, open the SQL Monitor web interface and connect to the Base Monitor.
This pairs your current Web Server to the Base Monitor.
If you want to connect the Base Monitor with new Web Server, but keep the connection to the old one:
- On the machine running the Base Monitor, go to %ProgramData%\Red Gate\SQL Monitor\
- Get a thumbprint by doing one of the following steps:
- If you see an error message "The web server isn't authorized to access this base monitor as the following thumbprint is missing: <THUMBPRINT>", get the thumbprint from it.
- Alternatively, you can get a thumbprint by running the following Powershell command on the machine running the Web Server from %ProgramData%\Red Gate\SQL Monitor\:
Get-PfxCertificate -FilePath "Red Gate Monitor.pfx"
- Add a new line with a thumbprint to RedGate.SqlMonitor.AuthorizedClients.config
- Try to connect again.