Hi,

I set up a new DotNetNuke installation (the latest 4.8.2) a while back, it only had one portal so I only logged into the host account maybe once or twice... now, I went to log back in and I either a) have forgotten the host username or b) the username I thought it was has somehow turned into a standard user. I tried to get into the database using the SQL Server 2005 management console, but it's giving me some sort of error saying the database is corrupt and asking if I want to fix it, despite it seeming to work fine!

Anyway, I added some script to the main default.aspx page to try to get to the bottom of this:

<%
dim userList = DotNetNuke.Entities.Users.UserController.GetUsers(0)
for each lzUser as DotNetNuke.Entities.Users.UserInfo in userList
 Response.Write(lzUser.username & " superuser = " & lzUser.isSuperUser & "<BR>")
next
%>

This is supposed to list all my users, and tell me whether they are a super user (I'm guessing a SuperUser has host access?). It lists all the users I know of - none of them are a SuperUser. If I try to set one of them to a super user in the same script, it still comes up as being false.

What's going on? Is there any way I can code something to add a new host user, or should I 'fix' the corrupt database as the management console is suggesting? I'm totally stuck until I get this fixed, but I'm not sure what else to try.

Thanks,

Chris.

i think there is a module at snowcovered to help you recover your superuser account. hope this helps.

check this module out:

http://www.snowcovered.com/snowcovered2/Default.aspx?tabid=242&PackageID=8350

You may be able to retrieve your host password with the following requirements:

1. This Is only for Version 4.05.05 of DNN!
2. You must have ftp access to your DotNetNuke website.
3. You must use the same version dll. (4.05.05)
4. You must know the SuperUser username.
5. The password will be sent to the email address on file for this user, so it must be a valid email address and you must have access to that email account\

Am I understanding your problem correctly?