Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

thanks&regards

kishore

Former Member
Former Member replied

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.

http://help.sap.com/saphelp_45b/helpdata/en/52/671792439b11d1896f0000e8322d00/content.htm

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.

Thanks,

Mofizur

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question