Monday, July 4, 2011

Unlocking user in T-SQL

If a user gets locked after a number of failed attempts, just run the following t-sql.

ALTER LOGIN userToUnlock WITH PASSWORD = 'themightypassword' UNLOCK ;

No comments:

Post a Comment