Reset DotNetNuke Login password

There’re many ways to reset DNN user password. As for SQL query, you can run the following on your database:

create procedure [dbo].[uap_ResetPassword]
@UserName NVarChar(255),
@NewPassword NVarChar(255)
as
begin
Declare @PasswordSalt NVarChar(128)
Declare @ApplicationID NVarChar(255)
Declare @ApplicationName NVarChar(255)
Set @ApplicationID = (SELECT [ApplicationID] FROM aspnet_Users WHERE
UserName=@UserName)
Set @ApplicationName = (SELECT [ApplicationName] FROM aspnet_Applications WHERE
ApplicationID=@ApplicationID)
Set @PasswordSalt = (SELECT PasswordSalt FROM aspnet_Membership WHERE UserID IN (SELECT UserID FROM aspnet_Users WHERE
UserName=@UserName))
select @ApplicationID, @ApplicationName
declare @RetVal as int
Exec @RetVal = dbo.aspnet_Membership_ResetPassword @ApplicationName, @UserName, @NewPassword, 10, 10, @PasswordSalt, -5
return @RetVal
end

The most simple way is this one:

If you know another site user login id/password let’s say user1. you can connect to your dnn database > open the user table > edit the user1 and check the box ‘is superuser?‘ and save to exit. Now you have superuser privileges on user1 this id, you just login to the dnn site and reset other user password.

Share

- has written 121 posts.


Leave a Reply

You must be logged in to post a comment.