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.

==========================================================