If you're a plonker like me and have forgotten a password, you have 2 options:
- Call the 'aspnet_Membership_ResetPassword' sproc.
- Simply update the aspnet_membership table manually by copying the password and passwordSalt column values from another user (whose password you know). Here's some code I used:
declare @u uniqueidentifier
set @u = (select userid from aspnet_users where username = 'userwhosepswdyouknow')
UPDATE aspnet_Membership
SET
[Password] = (select password from aspnet_membership where userid = @u),
[PasswordSalt] = (select passwordsalt from aspnet_membership where userid = @u)
WHERE userid = (select userid from aspnet_users where username = 'userwhosepswdyoudontknow')
select password, passwordsalt from aspnet_membership m
HTH
Tim