Unable to login with SAP* user.

[Former Member]

Hello,

I have setup the R3 system with Primary system backup and to activate the license I wanted to log in with SAP* user.

But when I'm trying to login in client 000 and it is showing "Password logon no longer possible - too many failed attempts"

So to reset the sap* user password I have followed the below steps :

Unlock & Reset SAP* Password in Oracle - Basis Corner - SCN Wiki

And it executes properly, but still I'm getting the same error.

Can you please help on this.

Thanks in advance.

[manumohandas82]

Hi Purushottam ,

1 ) Set the following profile parameter in your system first  [ In DEFAULT.PFL ]

login/no_automatic_user_sapstar=0

If the above parameter is in any of the instance profile remove the same

2 ) select * from <SCHEMA>.USR02 where BNAME='SAP*' [ Check whether you have SAP* user in any of the clients ]

3 ) If you have

delete from <SCHEMA>.USR02 where BNAME='SAP*'

4 ) commit

5 ) restart you application server [ SAP Aapplications  , DB  restart not required  ]

If you still have issues , believe it could be because of the Kernel . Replace the kernel to the latest available and try once again

Thanks ,

Manu

[Former Member]

check the profile parameter login/no_automatic_user_sapstar

0: Automatic user SAP* is permitted

1: Automatic user SAP* is deactivated

[Former Member]

Hi Sunil,

Its "0" like "login/no_automatic_user_sapstar=0"

[Former Member]

Hi,

did you delete the User SAP* in the affected client of the SAP System? You have to set the mentioned parameter and you have to delete the User SAP* if exist in table USR02 otherwise Kerneluser SAP* can not be used with standardpassword

Regards

Robert

[Former Member]

Dear Robert,

Thanks for your reply.

yeah i have deleted the user from table USR02 by using below command:

"delete from SAPSR3.USR02 where BNAME='SAP*' and MANDT=000;"

[Former Member]

hey,

can you try to set MANDT also in singlequotes?

delete from SAPSR3.USR02 where BNAME='SAP*' and MANDT='000';

i think sapsr3 is the right schema for you?

Regards

Robert

[Former Member]

Dear Robert,

Can you tell me in command?

Means you want me to execute the command like below?

delete from SAPSR3.USR02 where BNAME='SAP*' and 'MANDT'='000';

[Brindavan_M]

Hello,

The link which you are posted step is correct ,   but you have to check the database schema might different for other SAP system like PI, SRM kindly check the schema as well and also check the DEFLUAT profile the same parameter login/no_automatic_user_sapstar =<value> might be exits in that profile.  check and set the parameter and follow the steps.

let us know if you still facing the issue.

Thanks,

BM