Note: This article only applies if using the built in SQL Monitor accounts
Only administrators can reset SQL Monitor passwords.
Resetting standard and read-only user passwords
If you're a standard or read-only user and you've forgotten your password, contact a SQL Monitor administrator. Administrators can change passwords by following the instructions under Editing user roles in Managing user roles.
Resetting administrator passwords
If you use Active Directory
To reset the administrator password, you need to delete the password stored in the SQL Monitor database.
-
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. -
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)
. - The Create Administrator password page is displayed. Enter a new administrator password.