How to unlock SAP* user in Ms SQL database
Whenever SAP* user got locked (mainly in 000 Client), in most cases we are supposed to unlock the SAP* User in database level.
Before logging into SAP system using SAP* user, be aware whether the parameter login/no_automatic_user_sapstar is set to value 0 (Zero).
If the value of parameter login/no_automatic_user_sapstar is set to 1, it will not allow the SAP* user to login to the SAP system.
Steps to Unlock the SAP* user (DB level)
1. Try login SAP system with SAP* user
SAP* user got locked due to too many attempts with wrong password.
2. Login to Ms SQL Database,
3. Execute the query:
select * from er1.USR02
The status of the user is locked/Not locked is identified in the field UFLAG.
In the above screenshot, value of UFLAG is 128 for the user SAP*, means the SAP* user got locked.
Note : If the value of UFLAG results in a Non-Zero value, then it means that the user got locked.
4. Execute the query:
select * from er1.USR02 where BNAME=‘SAP*’ and MANDT=‘000’ to find the details of only SAP* user.
For Unlocking the user, the value of UFLAG should be set to 0 (Zero).
5. Execute the query:
update er1.USR02 set UFLAG=‘0’ where BNAME=‘SAP*’ and MANDT=‘000’
6. Now execute the query :
select * from er1.USR02 where BNAME=‘SAP*’ and MANDT=‘000’
Now the Value of UFLAG has been altered to 0.
SAP* user has been unlocked.