Ismet posted on October 02, 2008 12:03
Sometimes DotNetNuke users somehow forgot their password for host account log in, because of that issue they would not be able to do actions at DotNetNuke portals that require host privileges.
In this article i am going to cover all needed information to recover and reset host account password for your DotNetNuke (DNN) Portal.
Before Begin
Ensure that you have access to your DotNetNuke Installation (e.g www.onlydnn.com). You must be able to Register a new user account at your dnn installation, unless you know the password of one of the registered users of your portal.
Ensure that you have access to SQL Server Database (If you have Dedicated Server or localhost installation you can use SSMS - SQL Server Management Studio. Otherwise you will need to access your Hosting Control Panel and manually edit Database Tables, like you will do with SSMS).
How to Reset Your Host Account Password
Connect to your website (e.g www.onlydnn.com) and register a new user account. (e.g username: host25, password: mg3X7V3pi)
Open SSMS (SQL Server Management Studio) and connect to database server using Windows Authentication.
Expand Databases tab from Object Explorer.
Expand the Database then expand Tables from list.
Right click to dbo.aspnet_Membership and click Open Table from menu.
You will see values assigned to columns such as:
- ApplicationId
- UserId
- Password
- PasswordFormat
- PasswordSalt
- Email
Now you need to copy Password and PasswordSalt value of new user (host25 in this article) and paste these values to Password and PasswordSalt of Host user at dbo.aspnet_Membership table.
After changing Password and PasswordSalt values as instructed you should be able to log in your DotNetNuke portal using Host Account.
Note: Please share your thoughts by adding comments. It's also welcomed to share alternative ways such as SQL Queries that users can run via Query Analyser.