Does anyone know how I can login as a SuperUser based on the following?
I can't login as a SuperUser at all on my site. I've checked IsLocked and tried creating a new user and copying the passwords and salts but this doesn't work.
When I create a new user, I can login as that new user. But then, as soon as I change IsSuperUser to TRUE I can't login anymore. However, under no circumstances can I login using the host account, even if I change IsSuperUser to False.
I've also tried running the following SQL at the end of this post which didn't change anything.
If it helps, what caused the problem is that I was trying to make a page where the user could edit their password, but not see their other contact information. I made some changes to that page so that the contact information didn't appear, I was logged in as host, and then when I clicked update password, it didn't update, and now I can't login as host anymore.
The site is very well developed and I wouldn't want to reinstall if I there is any other way. This is ver 4.0.2.
Thanks!
Here is the SQL I mentioned:
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 = 'newpassword' --New password
-- Do modify any code below this line
Set
@Application = (SELECT [ApplicationID] FROM aspnet_Users WHERE UserName=@UserName)
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