Reset admin pasword from database - General Discussions - General Discussions - Progress Community
 General Discussions

Reset admin pasword from database

  • Reset admin pasword from database
  • 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?
  • 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.
  • 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.
  • Anyone ever figure this one out (the re-salting)?
  • 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.
  • @Dustin ...that's just brilliantly simple :)  Nice job!
  • if the above solutions fails then you can also take help from SQL Password Recovery Tool to reset admin password from database