+1-888-365-2779
Try Now
More in this section

Forums / General Discussions / Reset admin pasword from database

Reset admin pasword from database

7 posts, 0 answered
  1. Renatas
    Renatas avatar
    14 posts
    Registered:
    02 Aug 2011
    13 Feb 2012
    Link to this post
    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?
  2. Robin
    Robin avatar
    15 posts
    Registered:
    03 Aug 2011
    13 Feb 2012
    Link to this post
    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.
  3. Corbett
    Corbett avatar
    6 posts
    Registered:
    31 Jan 2012
    17 May 2012
    Link to this post
    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.
  4. Steve
    Steve avatar
    3037 posts
    Registered:
    03 Dec 2008
    29 Oct 2012
    Link to this post
    Anyone ever figure this one out (the re-salting)?
  5. Dustin
    Dustin avatar
    20 posts
    Registered:
    05 Jan 2012
    12 Mar 2013
    Link to this post
    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.
  6. Steve
    Steve avatar
    3037 posts
    Registered:
    03 Dec 2008
    12 Mar 2013 in reply to Dustin
    Link to this post
    @Dustin ...that's just brilliantly simple :)  Nice job!
  7. Johnson
    Johnson avatar
    0 posts
    Registered:
    26 Aug 2016
    26 Aug
    Link to this post

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

7 posts, 0 answered