Multiple Webservers for SQL Monitoring Service
ClarkChris
Posts: 8 Bronze 1
We have 3 DBA's that would like to use the SQL Monitoring Webpage from their individual workstations. Is it possible to configure multiple webservers for one SQL Monitoring Service Account? If not, then if we only have one webserver configured, is there a way to connect from our local workstation's browser without having to connect with RDP into the Webserver?
Currently, we find that each DBA is having to reconfigure the Webserver settings to their own workstation each time overwriting the previous user's configuration, subsequently disabling the former user's connection. The end result were expecting is for each of our DBA's to be able to connect to the Webserver from their respective local workstation simply by launching the 'SQL Monitor 4 Website API'.
Thank you for your assistance!
Currently, we find that each DBA is having to reconfigure the Webserver settings to their own workstation each time overwriting the previous user's configuration, subsequently disabling the former user's connection. The end result were expecting is for each of our DBA's to be able to connect to the Webserver from their respective local workstation simply by launching the 'SQL Monitor 4 Website API'.
Thank you for your assistance!
Comments
Configuring multiple webservers for the SQL Monitor:
To be able to launch and use ‘SQL Monitor 4 Website’ API from your individual machine, you need to configure your local machine to host the webserver for SQL Monitor.
You might be getting this error message when you first try to connect to the base(monitoring server)-
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.
Once you pair the base monitor to a new web server, you won't be able to connect using the old web server. To preserve existing webserver connection, save the guid string from the RedGate.Response.AuthorizedClients.config from below somewhere and make sure all connections are logged off.
1. On the machine running the base monitor, go to %ProgramData%Red GateSQL Monitor 42. Delete RedGate.Response.AuthorizedClients.config
3. 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.
4. Add back the existing guid string to preserve the existing webserver connection.
Now you should have successful connection between your machine and the base server.
You would still need to provide your logon and password to actually view the dashboard.