Skip to Content
avatar image
Former Member

how to unlock sap* and ddic in bi server

hi experts,

we installed long back bi server in windows 2003 on vm were.but we forgot the password.we are using db as oracle.

i tryed by changing the parameter login/no_automatic_login_sapstar=0 and restarted the instance.but even though i am unable to login that.can any one guide me how to unlock them if any alternate procedure is available.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Oct 29, 2015 at 07:48 AM


    If you have another super user with sap_all and sap_new you should be able change those two password using the super user id.

    I would suggest to put the question in SAP NetWeaver Application Server

    as this is related to basis activity.



    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      You can follow below steps

      1) Set the parameter login/no_automatic_login_sapstar=0

      2) Restart SAP Instance

      3) Check the parameter value reflected or not.

      4) Login to the DB level and delete the user SAP* for the required client using below query

        DELETE FROM <schema>.USR02 where BNAME='SAP*' and MANDT='client no'

      5) Try to login to SAP using SAP*/pass to the required client.

      If you want to UNLOCK only then you can do it from DB level using below SQL query..

      UPDATE <schema>.USR02 SET UFLAG=0 WHERE BNAME='USER' and MANDT='client'

      SQL SYNTAX can vary depending on your DB.

      Hope this helps.