on 07-16-2012 1:26 PM
Hi,
I am unable to login to the system as SAP Administrator in SAP ERP 6.0. But using the 'SAP*' user, I am able to login to the system successfully. Request your support.
Regards,
Praveen
Hi Bishwanath,
Thank you for the quick response.
I am getting 'name/password incorrect' as the error message. Kindly note that, this is my first installation; so I am not really sure if there is any usual action missing from my side.
Thanks,
Praveen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can fix that by logging on to sqlplus.
You may need to find out who the DB owner is (SAPR3 or SAPSID).
Here are the steps assuming the owner is SAPSID:
1) sqlplus> /as sysdba
2) First select the record to be edited to make sure it exists in that
client
- select bname from sapSID.usr02 where mandt = '000' and bname 'SAP*';
3) - delete from sapSID.usr02 where mandt = '000' and bname 'SAP*';
- commit work;
Now you can open SAPGUI with client x... and login with SAP* and
password PASS.
This fix only works if the login/no_automatic_user_sapstar instance
parameter is set to 0.
after that login with the default sap* password, kindly let me know after doing this step
To reset SAP* password, please follow this step:
1. Set the profile parameter login/no_automatic_user_sapstar to 0 from RZ10 (If you can’t logon, you can edit your Instance Profile directly from the OS level, folder /usr/sap/<SID>/SYS/profile, )
2. Restart Application Server.
3. Logon to your SQL command (eq: SQL PLUS for Oracle) and connect as SYSDBA.
4. Run: SELECT * FROM [DBSID].USR02 WHERE BNAME=’SAP*’ AND MANDT=’<client>’
Example: SELECT * FROM PRD.USR02 WHERE BNAME=’SAP*’ AND MANDT=’000′
5. If exist, then run:
DELETE FROM PRD.USR02 WHERE BNAME=’SAP*’ AND MANDT=’000′
Make sure the user deleted by re-run step 4.
hope this will help u ......
Regards
Bishwanath kanjilal
1. Using the tcode RZ10, I am able to get 'Edit Profile' window, but there is no profile available for modification. As you mentioned, I tried to change the parameter at OS level. The files which are available under the path '/usr/sap/<SID>/SYS/profile' is not having any variable like 'login/no_automatic_user_sapstar'.
Please share your comments.
Thank you.
hi parveen ,
i think u have not imported the profiles of active servers, with tx-RZ10 u need to import the profiles of active server, than u can modify the profile values.
for ur convenience i am attaching link just follow that link having screen shots http://sap.knowledgehills.com/How-to-Maintain-or-Manage-SAP-R-3-Profiles-transaction-RZ10/a24p2
hope this will help u .
Regards
Bishwanath kanjilal
Hello Bishwanath,
I was able to add this parameter, but on restart the parameter was not available in my default profile.
As I mentioned in the beginning, this is my first installation experience. I did installation based on the instguides, but possibly leaving some post installation steps.
Do you suggest any document I should follow to verify the correctness of installation and including post installation tasks, especially for someone completely new to SAP.
Thanks a lot for your support.
Praveen
hi parveen ,
post installation are very important for the smooth running of the system, generally at the start of the SAP carrier, installation part is the base n after that there are lots of thing to be learn ..
you have joined the right community, SAP is vast documented, u can any topics on internet.
Or u can contact me at bishwanath.kanjilal@bhushansteel.com.
Regards
BIshwanath kanjilal
can u give the error msg or simply u forget the password, or if u have made a copy of the user SAP* with all the authorization
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.