General information
Category:
Third party products
>>I've upgraded from DNN 3.00.13 to 3.03.04 and now I can't log in with the admin or the host accounts. The passwords must have been reset during the upgrade. Which of the SQL tables are these stored in so that I can overwrite them?
>
>Evan,
>
>I had this same problem recently. I do not have the code here at work, but I can tell you that the passwords are stored in the aspnet_Membership table. You have to update the proper row with a new password and passwordsalt. Both are encrypted so the idea is to register a new user with a password that you know, then update the rows with the password and passwordsalt of the new user account.
Thanks Keith. For future people that have the same problem, here is the specific solution
1) Open your database in Enterprise Manager or SQL management studio
2) Open the portals table and change the UserRegistration field to 2, to allow new accounts to be created
3) Open your DNN portal in a browser, and click "register" to create a new account
4) From SQL server, open the aspnet_membership table and copy the contents of the password and passwordsalt fields from the newly created row to the row for your admin and host accounts. Hopefully you can determine this from the account creation date or email address associated with this accounts.
5) Voila! Log in using the new password
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only