One way of Password retrieval
Sometime it happens that you have forgotten the host password of DNN portal and you are also not able to request the password through forgot password email. In this case what will we do now, since password is stored in encrypted format with Salt associated with it. The mentioned solution may help you.
1. Go to the DotNetNuke portal and register yourself as a new user . If “Register” is not displayed for the portal, go to table “Portals” in your database and enter value “2″ into column “UserRegistration”.
2. Create a new user account by registration (please remember the password this time the one you entered)
3. Go to database, and find and enter the table “ASPNet_Membership”
4. Go to new user account (usually the last one) and copy the encrypted values of columns “Password” and “PasswordSalt” into the same columns of user account “host” (usually the first entry in this table)
5. Login as user “host” using the new password and delete the newly created other user.
6. Complete!
Note : This solution may help you in DNN 3 and 4.
Shaukat Ali
Sr.Software Engineer
www.idslogic.com
thanks,nice article about password retreival