Redgate Monitor 14

Switching back to Redgate Monitor basic authentication

In some situations, you may need to return Redgate Monitor to basic authentication.

  1. Switch the Redgate Monitor authentication mode back to its default mode of using basic authentication by removing any authentication configuration:
    1. In Management Studio, connect to the SQL Server instance that hosts the Redgate Monitor database.
    2. Open a new query window targeted at the data repository (RedGateMonitor database by default).
    3. If you have configured Active Directory authentication, paste the following SQL script into the query window:

      DELETE FROM [settings].[KeyValuePairs] WHERE [KeyName] = 'AuthenticationType'; 
      DELETE FROM settings.ActiveDirectoryDomains; --optional, to delete any existing configuration
    4. If you have configured OpenID Connect, paste the following into the query window:

      DELETE FROM [settings].[KeyValuePairs] WHERE [KeyName] = 'AuthenticationType'; 
      DELETE FROM [settings].[KeyValuePairs] WHERE [KeyName] LIKE 'OIDC-%'; --optional, to delete any existing configuration
    5. Run the script.

  2. If you do not remember the Redgate Monitor basic authentication administrator password, follow these instructions to reset the Redgate Monitor administrator password.
  3. Restart the Web Service (or website and application pool, if you're using IIS).
    To restart the Web Service: from the Start menu, open Services, right-click Redgate Monitor Web Service, and select Restart.
    To restart the website and application pool (if you're using IIS): open IIS Manager and, in the Connections sidebar, right-click the website Redgate Monitor uses. Click Manage Website, and select Stop. Then click into Application Pools and right-click on the application pool the site uses.  Select Stop.  Lastly, restart the application pool by right-clicking it and selecting Start and then the website by right-clicking it and clicking Manage Website and then selecting Start.

You may now reconfigure Active Directory authentication or OpenID Connect authentication if you wish.


Didn't find what you were looking for?