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/