SQL Monitor - 2.3

SQL Monitor

Resetting your SQL Monitor password

To reset the password used to log in to SQL Monitor, you will need to delete the current password stored in the SQL Monitor Data Repository database:

  1. Log in to the SQL Server instance hosting your SQL Monitor Data Repository database.
  2. In SQL Server Management Studio (or equivalent SQL editing tool) run the following query:

    USE RedGateMonitor

    GO

    DELETE FROM settings.UserAccount

    (where RedGateMonitor is the name of the database you are using for the Data Repository).

  3. Paste the URL for SQL Monitor into your browser address bar, e.g. http://MyServer.mydomain:8080.

    Note: If your browser displays a message asking if you want to repost the data, ignore it. Reposting will enter the password you have just deleted.

  4. The Create password page is displayed. Enter your new password.

Was this article helpful?

Search support
Forums
Visit the SQL Monitor forum.