Problems with the sap* password

[Former Member]

Hi,

i have a problem with the sap* password.

I tried my masterpassword but it did not work.

So i tired the following from the Tread:

-

---

resetting password for sap*

sqlplus "/as sysdba"

sql> update sapsr3.usr02 set bname='SAP1' where bname='SAP' and MANDT=000;

sql> commit;

-

---

Bud it did not work. After i tried to delete the sap*1 from the table sapsr3.usr02 but it did not work.

sql>delete from sapsr3.usr02 where mandt='000' and bname = 'SAP*1';

-

---

I also restarted the instance after the commands. But i can not logon with 'sap*' and the password 'pass' .

Mybe someone can help me?

Regards

Mike

[markus_doehr2 · Accepted solution]

Starting with release 7.00 based system you have to set

login/no_automatic_user_sapstart=0

in your instance profile and restart the instance.

Markus

[Former Member]

It works!

Thank you Markus!

Regards Mike

[Former Member]

Hi Mike,

great to hear! Please change the status of this post to answered and reward some points.

Markus