The Web Server isn't authorized to access this Base Monitor
Published 14 February 2023
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, see Moving the web server to a different machine.
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.