cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Administrator initial login failure

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

How can I verify login/no_automatic_user_sapstar instance parameter is set to 0....

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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