If you need to manually unlock a user account in Infor Syteline, and you don’t want to wait for the default 30 minute lock out period to expire, start the SQL Server Management studio. Then connect to your Syteline database server.

Click on the New Query button in the upper left hand corner.

image

On the right hand side, in the SQL Query window, user the following:

UPDATE UserNames SET Status = 0, LoginFailures = 0 WHERE Username = ‘sa’

Above will unlock the sa account. Use the username of the account instead of sa to unlock a different user.

%d bloggers like this: