Need access to SAP* but login/no_automatic_user_sapstar=1

[Former Member]

Hi I completed a refresh of a system from a backup of another system but I need to be able to log in now via sap. I deleted the sap entry in the DB but I cannot log into my system with the default password PASS. I suspect the parameter login/no_automatic_user_sapstar=1. Is there a way I can log in to the system still (I don't have any other credentials to log into the system and change the parameter).

I executed these statements:

SQL> DELETE from SAPBIX.USR02 where MANDT='000' and BNAME='SAP*';

1 row deleted.

SQL> commit;

Commit complete.

SQL>

But I cannot login the application layer, I am getting "Name of password is incorrect (repeat logon)"

Is there any type of fail-safe for a situation like this?

Kindly,

Omar

[markus_doehr2]

> Is there any type of fail-safe for a situation like this?

Open the instance profile with a text editor, add

login/no_automatic_user_sapstar = 0

to the bottom, save the file and restart the instance. Then you can logon with SAP*.

Markus

[Former Member]

thank you very much. it worked.