忘记DotNetNuke的host密码？-如何恢复丢失的DNN密码

有时候我们会忘记DotNetNuke的host密码，这是一件很头疼的事，这时我们可以通过下面这一段SQL Script把host密码重置为一个已知用户的密码（假设这个已知用户名为m2land)。

原理其实很简单，这段Script会把aspnet_membership表中的"m2land"用户的password和password_salt值拷贝并覆盖host对应的值。
使用方法请参考script中的说明。

/*
 -- Database Utility ---------------------------------------------------------------------------
 Description : Reset a Password in a DotNetNuke database
 Author : Tony Tullemans
 Date Created : 18.04.2007
 Note/s : Before you run this script you must know the UserName and Password of another
 registered DNN user in the database you wish to affect.
 -----------------------------------------------------------------------------------------------
  */
 
DECLARE   @databaseName   VARCHAR ( 128 )
SELECT   @databaseName   =   DB_NAME ()
 
PRINT   ' RESET PASSWORD IN DATABASE :  '   +   @databaseName
PRINT   ' ----------------------------- '   +   REPLICATE ( ' - ' ,  DATALENGTH ( @databaseName  ));
 
DECLARE   @knownUserName   NVARCHAR ( 128 )
DECLARE   @lostUserName   NVARCHAR ( 128 )
DECLARE   @lostUserId   NVARCHAR ( 128 )
DECLARE   @knownPassword   NVARCHAR ( 128 )
DECLARE   @knownSalt   NVARCHAR ( 128 )
 
SET   @knownUserName   =   ' m2land '
SET   @lostUserName   =   ' host '
 
SELECT   @knownPassword   =  Password,  @knownSalt   =  PasswordSalt
FROM  aspnet_Membership
INNER   JOIN  aspnet_users
ON  aspnet_Membership.UserId  =  aspnet_users.UserId
where  UserName  =   @knownUserName ;
 
PRINT   ''
PRINT   ' Known Password for " '   +   @knownUserName   +   ' " is :  '   +   @knownPassword
PRINT   ' Known Password Salt for " '   +   @knownUserName   +   ' " is :  '   +   @knownSalt
 
SELECT   @lostUserId   =  aspnet_Membership.UserId
FROM  aspnet_Membership
INNER   JOIN  aspnet_users
ON  aspnet_Membership.UserId  =  aspnet_users.UserId
WHERE  UserName  =   @lostUserName ;
 
PRINT   ''
PRINT   ' UserID for " '   +   @lostUserName   +   ' " is :  '   +   @lostUserId
PRINT   ''
 
IF  ( DATALENGTH ( @lostUserName )  <=   0   OR   @lostUserName   IS   NULL )
PRINT   ' Invalid Lost User Name  '   +   @lostUserName
ELSE   BEGIN
IF  ( DATALENGTH ( @knownUserName )  <=   0   OR   @knownUserName   IS   NULL )
PRINT   ' Invalid Lost User Name  '   +   @lostUserName
ELSE   BEGIN
IF  ( DATALENGTH ( @knownPassword )  <=   0   OR   @knownPassword   IS   NULL )
PRINT   ' Invalid Known Password  '   +   @knownPassword
ELSE   BEGIN
IF  ( DATALENGTH ( @knownSalt )  <=   0   OR   @knownSalt   IS   NULL )
PRINT   ' Invalid Known Salt  '   +   @knownSalt
ELSE   BEGIN
PRINT   ''
PRINT   ' BEFORE '
SELECT   left (UserName,  12 )  as  UserName, aspnet_Membership.UserId,  left (Email,  20 )  as  Email, Password, PasswordSalt
FROM  aspnet_Membership  INNER   JOIN  aspnet_users  ON  aspnet_Membership.UserId  =  aspnet_users.UserId
WHERE  UserName  IN  (  @knownUserName ,  @lostUserName  );
PRINT   ''
PRINT   ' Changing Password for User Id : " '   +   @lostUserId   +   ' " to " '   +   @knownPassword   +   ' " '
PRINT   ''
UPDATE  aspnet_Membership
SET  Password  =   @knownPassword ,
PasswordSalt  =   @knownSalt
--  SELECT UserId, Password, PasswordSalt
--  FROM aspnet_Membership
WHERE  UserId  =   @lostUserId ;
PRINT   ''
PRINT   ' AFTER '
SELECT   left (UserName,  12 )  as  UserName, aspnet_Membership.UserId,  left (Email,  20 )  as  Email, Password, PasswordSalt
FROM  aspnet_Membership  INNER   JOIN  aspnet_users  ON  aspnet_Membership.UserId  =  aspnet_users.UserId
WHERE  UserName  IN  (  @knownUserName ,  @lostUserName  );
END
END
END
END
GO

PRINT   ''
PRINT   '  * * * END OF SCRIPT * * * '
PRINT   ''
GO

SQL Script recovering host password use asp.net store procedure
-------------------------------------------------------------------------------------

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

-------------------------------------------------------------------------------------