Only administrators can reset passwords.

For standard and read-only users

If you're a standard or read-only user and you've forgotten your shared password, contact a SQL Monitor administrator. Administrators can reset these passwords by following the instructions in Managing user roles.

For administrators

To reset the administrator password, you need to delete the password stored in the SQL Monitor database.

1. Log into the SQL Server instance that hosts the SQL Monitor database.
   In Management Studio (or equivalent SQL editing tool), run:

   USE RedGateMonitor
   GO
   DELETE FROM settings.UserAccount WHERE UserName = 'admin'

   where RedGateMonitor is the name of the SQL Monitor database.

2. On the machine where the SQL Monitor website is installed, open a web browser and paste the URL for SQL Monitor into your browser address bar (eg http://MyServer.mydomain:8080).

   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.
3. The Create Administrator password page is displayed. Enter a new administrator password.

The new administrator password is set.