how to unlock sap* and ddic in bi server

[Former Member]

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 · Accepted solution]

Hi,

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

as this is related to basis activity.

Thanks.

-J

[Mofizur · Accepted solution]

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