Status
Login to your OS level and connect to the Microsoft SQL Server. Once connected, open a new query and type below command. It will shows you the status of user SAP*.
select MANDT, BNAME, UFLAG from SCHEMA.USR02 where MANDT=CLIENT-NO and BNAME='SAP*'
Unlock
Put below command to unlock the SAP* by set the UFLAG to 0. Now, you can login to your SAP* with the old password.
update SCHEMA.USR02 set UFLAG=0 where BNAME='SAP*' and MANDT=CLIENT-NO
Reset
If you are forgot your SAP* old password. You can reset the SAP* password by executing this command.
delete from SCHEMA.USR02 where BNAME='SAP*' and MANDT=CLIENT-NO
Note
• Default password for sap* is pass / 06071992.
• Execute transaction code /$tab to reset buffer
