on 06-29-2010 2:35 AM
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?
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Try to login with dcic user and create the sap* user for 500 client,
Thanks,
Sreeni.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.