Wednesday, March 23, 2011

ASP.NET Membership User Locked

PROBLEM:
ASP.NET membership user password cannot be reset

CAUSE:
User account is locked (caused by incorrect password being entered numerous times)

SOLUTION:
Unlock user account using SQL query:

DECLARE     @return_value int

EXEC  @return_value = [dbo].[aspnet_Membership_UnlockUser]
            @ApplicationName = N‘applicationName’,
            @UserName = N‘user’
SELECT      ‘Return Value’ = @return_value
GO


SOURCE:
http://codinglifestyle.wordpress.com/2010/02/13/unlock-user-via-database-query-asp-net-membership/

No comments:

Post a Comment