DNN Host account locked out

Hi Friends,

First time/novice users generally tend to do a lot of R&D after installing dotnetnuke, that’s when there is a possibility that your host account might get locked up.
Here’s a quick way to get around this problem :

Case 1:
Current skin and container on your dotnetnuke installation is the default skin and container.In which case you should be able to see the Register link before the login link on the home page.
In this case follow the points mentioned below -

Go to the home page of your browser.

Click the “Register” link and create a new user.

Go to the database of the dotnetnuke installation.

Open the Sql server query analyser and execute “Select * from users”

You should see your user in the list, execute
       “UPDATE Users
        SET IsSuperUser = 1
        WHERE UserID = “

1. Now log into the site, You should be able to log into the site and then in the Host->Host Accounts.
2. Search for your original host account, edit it and click the “Manage Password” link.
3. Since you have forgotten your current password keep that textbox blank, Enter the new password and confirm it.
4. Click the “Change Password” link.
5. Log out of the site.
6. Log in with the original host user now.
7. Once you are able to log in the site as your original host user go back to the database and execute
   UPDATE Users
   SET IsSuperUser = 0
   WHERE UserID =” this will reset the new user to a normal user (Remember that we had set this normal user as a host user).

Case 2:
Current skin and container on your dotnetnuke installation is your custom skin and container.In this case you may or may not have the “Register” link on your homepage.
In this case follow the same steps from steps -3 till the end.

That’s it you have successfully changed your host account password.