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

1. Switch the SQL 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 SQL 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 SQL Monitor basic authentication administrator password, follow these instructions to reset the SQL 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 SQL 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 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.  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.