Post reply

user lock

  • May 5, 2009 at 8:37 am

    #202842

    Hi,

    user is getting locked very frequently in sql 2005 and it is saying sa can unlock the user. I am the sa and I am trying to unlock using

    Alter login login name with PASSWORD = 'pwd_123' UNLOCK

    but it is occurring repeatedly. Please help to fix this permanently

  • May 5, 2009 at 8:45 am

    #988888

    What is the exact error? Locking can be caused by application not by user's action. In this case more work needs to be done. Try to look at locking and blocking instead of user's password lock.

    Alex Prusakov

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

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