Sunday, January 17, 2016

Lock/Unlock FBA Account

If you have FBA packed installed , it can be used to unlock an account but if you want to unlock many accounts SQL statement below can be used to do that.

Un-Lock FBA Account
Update [DBNAME]
set IsLockedOut=0 ,FailedPasswordAttemptCount=0

where  IsLockedOut=1 and   LastLockoutDate=DateAdd(Minute,30,LastLockoutDate)

P.S: where clause can be modified to add different criteria.  

No comments: