SQL Monitor 9

Incorrect service account credentials

If SQL 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 SQL 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 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:

      UPDATE settings.KeyValuePairs SET KeyValue = 0 WHERE KeyName = 'ActiveDirectory-Enabled';
    3. Run the script.

  2. 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): open IIS Manager and, under Connections, right-click the website SQL Monitor uses. Click Manage Website, and select Restart.

  3. Switch back to Active Directory authentication.

Do you have any feedback on this documentation?

Let us know at sqlmonitorfeedback@red-gate.com


Didn't find what you were looking for?