membership reset password using only the database

Reset the password in membership to something you know...

Limited use case...this only works if you have a username/password combination that you already know.

In the table aspnet_Membership find the username whose password is KNOWN.  Copy the values in the Password and the PasswordSalt columns from the KNOWN user into the cells for the UNKNOWN user.  This will set the password to KNOWN user and you are now able to login.