Reset admin pasword from database

Posted by Community Admin on 03-Aug-2018 10:07

Reset admin pasword from database

All Replies

Posted by Community Admin on 13-Feb-2012 00:00

Hey,

I fogot my admin password and smtp settings are not seted. Can I copy my hashed pasword from other sitefinity project (where i know pasword) and replace pasword with it? Or is it hashed with different key?

Posted by Community Admin on 13-Feb-2012 00:00

To reset a users password, you could try this:

1. Open SQL Management Studio
2. Select your database
3. Edit the sf_users table
4. For the 'admin' user :
    4.1 set column 'salt' to NULL (ctrl-zero)
    4.2 set column 'password_format' to 0 (zero)
    4.3 set the column 'passwd' to the plain text password you want.
5. Save the row

You should now be able to log in with the password specified.

Posted by Community Admin on 17-May-2012 00:00

This works. So once we've logged in, how do we change the password back to being salted? I used the profile to change my password but upon looking back at the database it is still unsalted.

Posted by Community Admin on 29-Oct-2012 00:00

Anyone ever figure this one out (the re-salting)?

Posted by Community Admin on 12-Mar-2013 00:00

not sure this helps...but what I did was null the salt, change the format to a 0, change the password as well. And then I created a "new admin" user, copied the salt, format, and password hash over. and was then able to change the password accordingly once the new salt was in place.

Posted by Community Admin on 12-Mar-2013 00:00

@Dustin ...that's just brilliantly simple :)  Nice job!

Posted by Community Admin on 26-Aug-2016 00:00

if the above solutions fails then you can also take help from SQL Password Recovery Tool to reset admin password from database 

This thread is closed