Post reply

Login account locked (Error: 18486)

  • October 22, 2014 at 8:25 am

    #291848

    I have a remote user who reported his account was locked out, error 18486, I tried unlocking it first using the following code

    ALTER LOGIN guesser WITH CHECK_POLICY = OFF;

    GO

    ALTER LOGIN guesser WITH CHECK_POLICY = ON;

    GO

    but that did not work. Then I tried changing the password with UNLOCK

    ALTER LOGIN guesser WITH PASSWORD = 'newpassword' UNLOCK;

    but that has not unlocked it. As the fake login indicates, the user tried to guess the password as shown in the event log. I also tried deleting the user to recreate it but the user is already logged in from different hosts and that is not allowed.

    What else can I do to unlock this user?

    Thanks in advance

  • October 22, 2014 at 12:55 pm

    #1754159

    My first attempt would be

    ALTER LOGIN guesser ENABLE

    Then again, it may be the fact that the guy is login which prevents UNLOCK from working.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]

  • October 22, 2014 at 1:08 pm

    #1754164

    That didn't work. I think you are right and the reason it is not letting me unlock him is because of all those sessions logged in from different hosts.

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply