Products

Solutions

Resources

Partners

Community

About

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeGetting StartedGetting StartedNew to DNN Plat...New to DNN Plat...Reset Superuser PasswordReset Superuser Password
Previous
 
Next
New Post
12/24/2012 2:44 PM
 

All,

 I'm brand new to dotnetnuke, inheriting a site from a developer who died.  I need to get the superuser password and am having some issues.  I'm in the database and can't find the user with username of "host" with the following:

 select * from aspnet_users where UserName like 'host';

 I found a user that I know the password and salt to copy over, but it seems like there is no superuser account.  Is this possible.  Am I looking in the wrong place?

Thanks,
Eric

 
New Post
12/24/2012 8:00 PM
 
The superuser must not be 'host' it can have any name. I would check the database using SSMS and look on the users table and check users who have set the value of column 'IsSuperUser' to '1'.  You can also modify the setting to other users e.g to your account and enable the IsSuperUser with setting the value to '1'.
 
New Post
5/13/2017 10:19 AM
 
I realize the answer is some 5 years old but having slightly different circumstances that this post helped me resolve, I will comment on how it helped.

I think of things too complex ... wanted to recover the host password with the query the new user above (as of 2012) commented on. Could not find it and didn't want the hassle of remoting into a server where I know the query is on the desktop. I know .... lazy, right? Guilty as charged.

I'd already created a user for the recover password query to work against to reset the host password and had actually been in search of where authorizing the user lived in the DNN database. Then stumbled upon Martin's answer.

One can simply SET IsSuperUser = 1 on the new user, even if not authorized. Then log in with that user and Presto! -- the user is automatically now authorized. I was hoping that would happen. Now I just navigated to host | Super User Accounts. For those totally new, just mouse over Host in the Nav bar, select the Settings Icon with the 2 gears in it -- the middle one. This displays the menu that includes Super User Accounts.

in Super User Accounts, edit the other host account password.

This avoids having to run a query at the database level to reset the host password. And where the username of 'host' has been changed, works around not being able to find it in the database.

 
Previous
 
Next
HomeHomeGetting StartedGetting StartedNew to DNN Plat...New to DNN Plat...Reset Superuser PasswordReset Superuser Password


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out