Morning All,

I have been given a DNN project to complete for my company that was started by a previous employee. Obviously we now don't have any passwords to logon and I am struggling to find out how to either reset the password or create a new host account.

I have tried to change the email address and get the password sent to me but the email functionality does not seem to be working in this project.

I have also run the following SQL script (below) that is floating around the internet but with no luck.

I am very new to DNN so any help would be greatly appreciated.

Thanks,
Gavin


Declare @UserName NVarChar(255)
Declare @NewPassword NVarChar(255)
Declare @PasswordSalt NVarChar(128)
Declare @Application NVarChar(255)

-- Enter the user name and new password between ''
-- do not leave any spaces unless intended to do so.
-- Edit only between single quote characters
Set @UserName = 'host' -- This default DNN host user
Set @NewPassword = '1' --New password
-- Do modify any code below this line

Set @Application = (SELECT [ApplicationID] FROM aspnet_Users WHERE UserName=@UserName)
print @Application
Set @PasswordSalt = (SELECT PasswordSalt FROM aspnet_Membership WHERE UserID IN (SELECT UserID FROM aspnet_Users WHERE UserName=@UserName))

Exec dbo.aspnet_Membership_ResetPassword @Application, @UserName, @NewPassword, 10, 10, @PasswordSalt, -5

you know if you have another account and  password for you can make it a superuser by setting a single column value.

---

DotNetNuke Search Engine
ASP.Net Search Engine
Email me to add your favorite sites to the search List.

The problem I had was that even though there where many accounts I didn't know a single password for any of them.

It is a good point though, what is the column which sets the superuser account?

Sorry I am very new at DNN.....