Password logon no longer possible - too many failed attempts and no any user sap* also locked

[shubham_annadate96]

I have installed sap trail system in my laptop but unfortunately sap* gets locked i want to reset it using database query how can i reset it please help me ?

[michael_loop]

Your question does not seem to be related to Advantage Database Server, so I have removed that tag and made the first of your secondary tags the primary one. Hopefully this will help you reach the appropriate people.

Mike Loop
Senior Support Engineer
SAP Product Support

[former_member185488]

Dear Shubham,

Please follow the below instructions,

1.Login to your DB.

2.Execute the below statement to check the sap* entry.

select * from <db_schema>.usr02 where mandt = ‘000’ and bname = ‘SAP*’;

3.Execute the below statement to delete the sap* entry.

delete from <db_schema>.usr02 where mandt = ‘000’ and bname = ‘SAP*’;

Kindly mention the respective client in the place of 'mandt'. Once you execute this command sap* entry will be deleted and will be created automatically so that next time you can login with default password of pass

Regards,

Jeganraj

[shubham_annadate96]

http://prntscr.com/i62usy