If you forget DNN password ,Then how you are going to recover.Think you can not remember both admin and host passwords.You can do nothing without admin & host password.
Yes there is a password reminder option.But it seems not working properly.Anyway I am bringing you a good option today.Run following SQL in the Query analyzer and run the command what I have given at the end.


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

-- now run this command with your username and password
uap_ResetPassword 'host','123'
uap_ResetPassword 'admin','456'



Save your time without wasting time to find the password recovery methods