Skip to Content
0

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

Jan 26 at 08:29 PM

107

avatar image
Former Member

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 ?

10 |10000 characters needed characters left characters exceeded

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

0
Further commenting has been locked.
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Jan 26 at 08:29 PM
0
Share
10 |10000 characters needed characters left characters exceeded
JEGANRAJ R Feb 20 at 03:44 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded