Manually activate user account in asp.net

Question

Hi, I have a (rather dumb) client who has created an account in our website, however, he cannot log in because he hasnt clicked the account activation link yet. for some reason, he doesnt want to click it (he thinks its virus)

anyway, I want to manually set the account to activated via database.. how do I do that? thanks!

( i mean, which fields needs to be changed to what values?)

Answer 1

Can't you temporary assign your own address to the account and resend the activation url? Maybe he can forward you the mail and you can click the link. Think that is easier than "hacking" your way into the membership provider.

Also calling your client dumb is not a very good way to handle your clients ;)

Answer 2

I did some fiddeling around the aspnet membership table and found out how to activate the account manually!

update aspnetdb.dbo.aspnet_Membership set IsApproved = 1 where UserId = (select UserId From aspnetdb.dbo.aspnet_Users where UserName = @Username)

the userid is ridiculously long so i found it easier to pick it up from username from users table.

Answer 3

call these two methods on your MembershipProvider.

        Membership.GetUser().UnlockUser();
        Membership.GetUser().IsApproved = true;