Incorrect service account credentials Incorrect service account credentials

Incorrect service account credentials

If Redgate Monitor is configured to authenticate users with Active Directory, and you're locked out of your Active Directory service account, you need to switch the authentication mode back to the default, restart the Web Service (or website, if you're using IIS), and then switch back to Active Directory authentication.

You won't be able to log in to Redgate Monitor (even as an administrator) to switch the authentication mode back to the default. Instead, you need to run a SQL script to do this.

  1. Switch the authentication mode back to the default:
    1. In SQL Server Management Studio, connect to the SQL Server instance that hosts the SQL Monitor database.

    2. Paste the following SQL script into a new query window targeting the SQL Monitor data repository and run it:

      DELETE FROM [settings].[KeyValuePairs] WHERE [KeyName] = 'AuthenticationType'; 
      DELETE FROM settings.ActiveDirectoryDomains; --optional, to delete any existing configuration
    3. Stop the Redgate Monitor Base Monitor service
      To stop the Base Monitor service: from the Start menu, open Services, right-click SQL 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 SQL 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 SQL 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 SQL 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.

Switch back to Active Directory authentication.

Related article:

Incorrect service account credentials