Can not logon to client with user sap*

[Former Member]

Hi All,

Our SAP system have 3 clients (100, 300 and 500) and DB2 database.

Now I can not log on to client 500 by all user. I use user sap* log on to 100 and set parameter value of "login/automatic_no_user_sapstar" to 0. After that, I try logon againt to 500 by user sap* / PASS, but still have the message : Password logon no longer possible - too many field attempts.

How can i fix it?

[Former Member · Accepted solution]

Hi,

Here is step by step process to unlock the users from DB

http://www.sap-img.com/basis/different-methods-to-lock-or-unlock-sap-users.htm

Thanks,

Sreeni.

[Former Member]

Hi,

The error message "Password logon no longer possible - too many field attempts" says that SAP* in 500 client is locked and since you are saying that there is no other user Id/password in client 500 to login, the only way I can suggest is unlock the SAP* at the database level if you know the correct password (I mean if pass is correct password or something else). If you dont know the correct password and there is no other user (DDIC or any user) to unlock then delete SAP* in client 500 at the database level, restart the instance once and then login with SAP*/pass

For unlocking

db2 => update dbschemaname.usr02 set uflag=0 where mandt='500' and bname='SAP*'

For deleting

db2 => delete dbschemaname.usr02 where mandt='000' and bname='SAP*'

Regards,

Sharath

[Former Member]

Hi

Please let me know step by step to do that, because I don't know DB2.

Thank you.

[Former Member]

Hi,

Try to login with dcic user and create the sap* user for 500 client,

Thanks,

Sreeni.

[Former Member]

Hi

I don't know pass for dcic (or ddic) user

[Former Member]

Hi,

The user is ddic and password is 19920706(Default).

Regards,

Vishnu

[Former Member]

Hi

I tried, but ddic / 19920706 can not log on any client