Hi Darryl

Perhaps you can make use of the build in "password reset" option by following the steps mentioned by Oriol in this post? https://our.umbraco.com/forum/using/ui-questions/4790-ouch-forgot-admin-password-how-to-reset#comment-289108

Also make sure to read the answer here if following Oriols instructions don't work alone https://our.umbraco.com/forum/using/ui-questions/4790-ouch-forgot-admin-password-how-to-reset#comment-293248

This should create an e-mail file on your local harddrive where you can click the reset link and then have a new password created if I'm not mistaken.

Hope this helps!

/Jan

Thanks Jan,

I'll give that a try. I'm just in the process of copying and pasting in the mailSettings and membership into the web config, to see if I can get Umbraco to generate the email file so I can reset the link.

One question before I go ahead with this... Do I paste in the original code for the membership in the web config once the password has been reset, as its quite a bit different from the original code. Specifically, I noticed the passwordFormat is set to Clear, but surely this needs to be set back to Hashed?

Hi Darryl

Yes I would change the settings back once the password reset mail link has been retrieved indeed.

Hope this works!

/Jan

Thanks again Jan,

Yes, I'll will try this soon and let you know how I get on...

I hope my fettling to the User DB in SSMS has not broken anything, because as it stands, I have an unhashed password in the DB, so I am hoping this process will overwrite the current U: admin, P: default and then hash it once I paste the original membership code in the web config without any issues.

Sadly, this doesn't work...

Even without the code changes to the web config, I'm getting this error:

But this may be something to do with the current password of default not being hashed? Also, the email I am using is 100% present in the database in SSMS.

Hi Darryl! Just had the same challenge last week.

Here are a few steps which I followed which worked for me

Download SDF Viewer (https://sdf-viewer.soft112.com/)

Then open your database with SDF Viewer (-/App_Data/Umbraco.sdf)

Find the table UmbracoUser

Update the table with the following query :

UPDATE umbracoUser set userdisabled=0, userLogin='admin', userPassword='rboj46J1NSyvbZ5c7UI/5+m+Pcc=' where id=0

Your new password will be 'default'

Then Rebuild your solution if you are in local

It should work normally

Nittin

Thanks Nittin,

I did wonder if there was a way of hashing a password, so it could be stored straight into the database. I have actually successfully run the query in SSMS and changed it to a hashed default.

I think to be honest, all of the fixes above are indeed valid, but I think there is something serious wrong with the two websites I've been given to reset the admin password, as Umbraco is not recognizing any of the registered emails in the database and is returning a stacktrace error (see picture).

These two websites are running from an external development server, so I have tried recycling the app pool, etc. and they are still acting oddly. Unless there is something I am missing? Do you think I need to redeploy these two sites to force them to do a rebuild?

Have you tried to run the query and change the 'userLogin' to another email address?

UPDATE umbracoUser set userdisabled=0, userLogin='newEmailaddress', userPassword='rboj46J1NSyvbZ5c7UI/5+m+Pcc=' where id=0

Nittin

Hi Nittin,

Yes, I've tried changing the userLogin to another email and it still fails to log me in. It just doesn't seem to acknowledge any of the entries in the dbo.umbracoUser table.

Is there any Update on this facing the same issue

I always use this package when stuck:

https://our.umbraco.com/packages/developer-tools/umbraco-admin-reset/

is working on a reply...