You forgot your administrator password and you need to make urgent changes in your Umbraco website. If your Umbraco application is up and running on any server (localhost, staging/production environment), so don’t need to waste your time by trying wrong password and get frustrated. All you need to follow below steps to reset your Umbraco admin password. Using the same method you can also reset any of the registered user’s password by knowing its record id stored in “umbracouser” database table.
Open SQL Server Management Studio (SSMS)
Login to your SQL server instance
Browse databases and Select your Umbraco Database by Single Click on it.
Click on create new query icon from tool menu to open new query window
Run the following SQL Command into new query window:run
UPDATE umbracoUser SET userdisabled = 0, userLogin = 'admin',
userPassword = 'default' WHERE id = 0
This will set your admin account to enable and the password to “default”.
Umbraco is saving user passwords in umbracouser table using hashed encryption technique, so you need to make temporary edits for some settings regarding user management in web.config file.
Open your Web.config from root level directory, and search for UsersMembershipProvider
You will find the passwordFormat property value is set to “Hashed”. You need to update it to “Clear” so that you can login.
Save the web.config file.
Now Go to umbraco login page and provide your username “xyz” and the password “default” and click on Login.
Boom! You find your user is logged in now.
Update the password from “default” to some other as you want for your admin user account from front-end UI.
Once you update your password from UI, you need to revert your web.config file changes back to “Hashed” from “Clear” and Save web.config.
Now your password will be saved in the database using hashed encryption technique instead of clear text.
It is very important to verify your password is saved in hashed value to follow security and privacy standards that you have updated from UI, you need to run the below SQL query:
SELECT userName, userPassword FROM umbracoUser WHERE id = 0
You will get result of admin user and check the password is stored in hashed format.
Hope this will help!