DotNetNuke – Retrieving Host Access


One of the most frustrating events that can happen in any system is forgetting your password and not being able to retrieve it.  DotNetNuke has a retrieval system built in, but you have to make sure your system can send mail in order to make use of it.

And even if it sends mail, it may be that you’ve taken over a system and the host account is not registered to you.

So what do you do?

Well, you can’t look in the database for the password because the passwords are hashed.  But there are some ways to get back in business.

First, let’s take a look at the easy way.  Let’s assume that you have the ability to sign up for a new account with a new password.  Go ahead and do that.

Next, open the database and look for the “Users” table.  This table has a bit field called “IsSuperUser.”  Set it to true.

Now log in as that user via DNN and you should be able to administer your system.  I’d go ahead and reset the original host and admin passwords.

If you haven’t allowed public sign-up for any of your DNN sites, you’ll have to enable public access by going into the database and looking for the “Portals” table.

In the “Portals” table there is a field called “UserRegistration.”  If you set this field to 2, you will be able to sign up as a new user.

Of course, if you don’t have access to the database, you are stuck.  But if you don’t have access to the database, you probably have no business trying to retrieve the host password, either.

Related Post

  • DotNetNuke Modules – Creating Base ModulesDotNetNuke Modules – Creating Base Modules
    Now that we have DotNetNuke installed into Visual Studio we can go ahead and create our first modules. Actually, creating the modules is pretty simple. But it is even easier to do it wrong, which...
  • Storing An Image To a Database in .NETStoring An Image To a Database in .NET
    Several weeks ago I mentioned that I store the images that the user uploads to the system into the database. Some of you have expressed an interest in how I do that.  So I plan to cover th...
  • The easiest way to create a SQL db from CodeThe easiest way to create a SQL db from Code
    (We'll get back to the series on Reflection next week.) So, I've started experimenting with replacing my TestComplete test scripts with CSharp test scripts.  This shouldn't be too big of a dea...
  • Internationalization – The DatabaseInternationalization – The Database
    Over the last several weeks we’ve been examining the various aspects of internationalization using ASP.NET. But it doesn’t help to have your resources and images set up for internationalization i...
  • Silverlight – Navigating DataSilverlight – Navigating Data
    Last week I demonstrated how to access data from a web service in Silverlight and display it on the page.  Today we are going to continue on with that demo and look at how to navigate through...