Htykuut

I'm having this weird problem with a user login in our Asp.Net application using Sql Membership Provider.

In the code, we first try to login using Membership.ValidateUser using the credentials entered on the login form; if this returns false, we try to retrieve data from the user name to check why the login failed.

    If Membership.ValidateUser(UserName, Password) Then

        Return True

    Else

        Dim mu As MembershipUser = Membership.GetUser(UserName)

        If mu IsNot Nothing Then

            If mu.IsLockedOut Then

                'returns message saying that user is locked

            End If



            If mu.IsApproved = False Then

                'returns message saying that user is disabled

            End If



            'returns message saying that either user or password are incorrect

        Else

            'returns message saying that either user or password are incorrect

        End If

    End If

Weird thing is that, Membership.ValidateUser returns false and it updates LastActivityDate in both aspnet_Membership and aspnet_Users tables, as well as FailedPasswordAttemptCount in aspnet_Membership; but
Membership.GetUser(UserName) returns nothing.

We also tried directly running the aspnet_Membership_GetUserByName stored procedure in the database and it does return data for said user name.

So far is the only user we have problem with; other users can login without problems.

Any ideas why the login is failing and the function GetUser returns nothing considering that the user does exist?