It was one of those days...
Typed in the password and swore I'd remember it!

But it got a typo in it and this post saved me...

To reset the admin password of a Umbraco website.

1. In SQL server, run the following script on the database:

USE  INSERT-YOUR-DATABASE-NAME-HERE
GO

UPDATE umbracoUser set userdisabled=0, userLogin='admin', userPassword='default' where id=0

1. In your web.config file, find the "UsersMembershipProvider" section, and change the setting:

passwordFormat="Hashed"
to
passwordFormat="Clear"

You should now be able to log in using the Username: admin and the Password: default.

---

This article was originally written on Google's Blogger platform and ported to Hashnode on 17 Sep 2022.