Thursday, June 16, 2011

Forgot the Password of sap* in 000 client

If you are able to login as DDIC or other Admin User Name , login and change the password of sap* . If you dont know any other admin passwords, the way left is delete the row of sap* from the Table usr02 .

Query is :
delete from usr02 where BNAME='sap*' AND MANDT='000';
In MS SQL, using Enterprise manager , delete the Entire row of BNAME=sap* and MANDIT=000 .

Note that the Profile parameter : login/no_automatic_login_sapstart should be set as 0 .
Otherwise go to rz10 > Extended maintanance > Select Instance parameter > Set the parameter login/no_automatic_login_sap* =0 , copy and save.
Restart the instance . You ll be able to login as sap* .

3 comments:

SAP Training said...

Excellent..SAP BASIS Training in Chennai

SAP Training said...

Very Nice
SAP Training in Chennai
SAP ABAP Training in Chennai
SAP FICO Training in Chennai
SAP SD Training in Chennai
SAP MM Training in Chennai
SAP PP Training in Chennai
SAP PM Training in Chennai
SAP QM Training in Chennai
SAP BASIS Training in Chennai
SAP MDG Training in Chennai

fm200 gas refilling price said...

This is a useful and practical SAP Basis guide for handling a forgotten SAP* password in client 000. The article clearly highlights the recovery approach, relevant USR02 considerations, and the importance of the login/no_automatic_login_sapstar profile parameter. A concise reference like this can be valuable for SAP administrators troubleshooting access issues during critical system administration tasks.