How to release a locked out user
Solution ID = KB-61
Goal : How to release a locked out user
Version = Syteline8.00.00
Module : SLADMIN
Fact : ADMIN
Database : SQL2005
Cause
Users fail to login to SL because entering incorrect password for multiple times. User status would be changed to Locked out automatically, and that particular user won't be able to login to syteline with correct password until the SL admin releases the accountFix
- Login as 'sa', open Users Form and go to 'Login Information' Tab and change User Login status = 'Active'
- In case your sa user gets locked out - Go to Microsoft SQL Server Management Studio, and run this script
update usernames
set status = 0, loginfailures = 0
where username = 'sa'
