on 04-09-2010 5:44 AM
Dear all,
i was upgraded my solution manger 3.0 to 4.0 it was successfully done by me without any error but now i m not able to login in the system with any default user id or password.
i tried sap* and ddic with default password but not able to login.
please help.
thanks for your suggestions but the value is already 0 i checked in my profile the value of login/no_automatic_user_sapstar = 0.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Delete from sapsr3.usr02 where bname = 'SAP*' and mandt = '000';
but i recived 0 row deleted.
Have you tried to login as user SAP* with password "PASS" in 000 client ?
SAP* user is hard-coded into SAP Kernel. If usr02 table is not having an entry for SAP* user with <client> (such as 000, 100 ,etc..etc.) entry , then one can login into <client> with PASS password.
Regards,
Bhavik G. Shroff
yes i tried to unlock sap* and delete the pass to default with Sql promt : delete
Delete from sapsr3.usr02 where bname = 'SAP*' and mandt = '000';
but i recived 0 row deleted.
it means its not deleting .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
If you are unable to login to SAP and has already deleted the entry from SAPSR3.US02, you can edit the instance profile manually at OS Level.
Add the below parameter:
login/no_automatic_user_sapstar = 0
in
For UNIX:
/sapmnt/<SID>/profile/<SID>_DVEBMGS<NO>_<HOSTNAME>
For Windows:
<drive>:\usr\sap\<SID>\sys\profile\<SID>_DVEBMGS<NO>_<HOSTNAME>
then restart the SAP and try to login as user SAP* and password "PASS".
Regards.
Rajesh Narkhede
Edited by: Rajesh Narkhede on Apr 9, 2010 2:36 PM
Hi,
login/no_automatic_user_sapstar profile parameter is maintained with 0 value ?
As of Release 7.0 (NetWeaver 7.0/2004s), The default value of the login/no_automatic_user_sapstar profile parameter has been changed from (previously) 0 to (now) 1.
So, to activate the emergency user, you must set the login/no_automatic_user_sapstar profile parameter to the value 0. You can login with sap* user only after such profile parameter activation.
After login with sap* user, you can unlock the DDIC user and also can change the password of DDIC user in login client.
As per this SAP Note 8852,
If no other password has been defined, user SAP* has password PASS
.
Regards,
Bhavik G. Shroff
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry it's How to unlock sap* in sap
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Unlock/reset the sap* from DB level and try to login.
Search SDN/google about unlock sap in sap*
Regards,
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Have you tried you old SAP*/DDIC password ?
Or the one which you have used in installation (Master Password) ?
Regards.
Rajesh Narkhede
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
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.