SQL Monitor - 3.0

SQL Monitor

Resetting your SQL Monitor password

Standard and Read-only users

If you are a Standard or Read-only user and you've forgotten your shared password, contact a user with Administrator permissions. Administrators can reset these passwords by following the instructions in Managing user roles.

Administrators

To reset the Administrator password, 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 UserName = 'admin'

    (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 Administrator password page is displayed. Enter a new Administrator password.

Was this article helpful?

Search support
Forums
Visit the SQL Monitor forum.
Learning SQL Monitor
Knowledge base

SQL Monitor

all SQL products

all products

Notes & articles

SQL Monitor

all SQL products

all products

Demos & walkthroughs

SQL Monitor