19-6-2009 11:3:22
Cũng có thể sửa pass được a Đức ah
Bạn làm thế này
Copy đoạn Code sau đó paste vào SQL2005 và Exec là OK liền: (nhớ sửa lại User/Pass của Acc host bạn cần Reset)
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 is a default DNN admin user; the default host user is 'host'
Set @NewPassword = '1234567' -- Your new password
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
---