DNN重置host密码

方法一：

要求条件是已知一个账户的账号和密码。可以通过手动方式重置，也可以通过下面的脚本。

/* -- 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 : ' + @databaseNamePRINT '-----------------------------' + 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 = PasswordSaltFROM aspnet_MembershipINNER JOIN aspnet_usersON aspnet_Membership.UserId = aspnet_users.UserIdwhere UserName = @knownUserName; PRINT ''PRINT 'Known Password for "' + @knownUserName + '" is : ' + @knownPasswordPRINT 'Known Password Salt for "' + @knownUserName + '" is : ' + @knownSalt SELECT @lostUserId = aspnet_Membership.UserIdFROM aspnet_MembershipINNER JOIN aspnet_usersON aspnet_Membership.UserId = aspnet_users.UserIdWHERE UserName = @lostUserName; PRINT ''PRINT 'UserID for "' + @lostUserName + '" is : ' + @lostUserIdPRINT '' IF (DATALENGTH(@lostUserName) <= 0 OR @lostUserName IS NULL)PRINT 'Invalid Lost User Name ' + @lostUserNameELSE BEGINIF (DATALENGTH(@knownUserName) <= 0 OR @knownUserName IS NULL)PRINT 'Invalid Lost User Name ' + @lostUserNameELSE BEGINIF (DATALENGTH(@knownPassword) <= 0 OR @knownPassword IS NULL)PRINT 'Invalid Known Password ' + @knownPasswordELSE BEGINIF (DATALENGTH(@knownSalt) <= 0 OR @knownSalt IS NULL)PRINT 'Invalid Known Salt ' + @knownSaltELSE BEGINPRINT ''PRINT 'BEFORE'SELECT left(UserName, 12) as UserName, aspnet_Membership.UserId, left(Email, 20) as Email, Password, PasswordSaltFROM aspnet_Membership INNER JOIN aspnet_users ON aspnet_Membership.UserId = aspnet_users.UserIdWHERE UserName IN ( @knownUserName, @lostUserName );PRINT ''PRINT 'Changing Password for User Id : "' + @lostUserId + '" to "' + @knownPassword + '"'PRINT ''UPDATE aspnet_MembershipSET Password = @knownPassword,PasswordSalt = @knownSalt-- SELECT UserId, Password, PasswordSalt-- FROM aspnet_MembershipWHERE UserId = @lostUserId;PRINT ''PRINT 'AFTER'SELECT left(UserName, 12) as UserName, aspnet_Membership.UserId, left(Email, 20) as Email, Password, PasswordSaltFROM aspnet_Membership INNER JOIN aspnet_users ON aspnet_Membership.UserId = aspnet_users.UserIdWHERE UserName IN ( @knownUserName, @lostUserName );ENDENDENDENDGOPRINT ''PRINT ' * * * END OF SCRIPT * * *'PRINT ''GO

我手动的方式就是将a的password何passwordsalt覆盖host的这两个字段就OK了。

这样host的密码就成了a的密码。

 

方法二：（更方便）

注册一个新用户testuser，然后去数据库中的users表找到刚注册的testuser用户，将IsSuperUser字段由false改为True。然后再用testuser账户登录DNN系统，admin->user account中将admin的密码重置就可以了。而host的密码要在host->SuperUser Account中重置。