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. Stop the Redgate Monitor Base Monitor service
   To stop the Base Monitor service: from the Start menu, open Services, right-click Redgate Monitor Base Monitor service, and select Stop.
   
   
4. Stop the Web Service (or website and application pool, if you're using IIS).
   To stop the Web Service: from the Start menu, open Services, right-click Redgate Monitor Web Service, and select Stop.
   To stop the website and application pool (if you're using IIS): open IIS Manager and, in the Connections sidebar, right-click the website SQL 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.
   
   
5. Restart the Redgate Monitor Base Monitor service
   To Restart the Base Monitor service: from the Start menu, open Services, right-click Redgate Monitor Base Monitor service, and select Restart.
   
   
6. Restart the Web Service (or website, 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 (if you're using IIS): right-click the application pool and select Start and then right click the website and click Manage Website and then selecting Start.

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