Skip to Content
avatar image
Former Member

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

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 ?

Add comment
10|10000 characters needed 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

Further commenting has been locked.
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 26 at 08:29 PM
    Add comment
    10|10000 characters needed characters exceeded

  • Feb 20 at 03:44 AM

    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

    Add comment
    10|10000 characters needed characters exceeded