SAP* login locked !!!??? how can i upgrade my license?

[Former Member]

Hello gurus,

My SAP* login of one of the system got locked, while updating the license. Now the thing is, my license is expired, can only log in through SAP* and that log in also locked how can i upgrade my license??

Thanks and Regards,

Rahul

[Former Member · Accepted solution]

Hi ,

If all the users are locked, they can be unlocked by

a)Try this command at ur sql plus query level

Go to cmd prompt.

Sqlplus /nolog

conn /as sysdba

this will take you to the sqlprompt.

Just execute the earlier commands there.

sqlplus><b>UPDATE SAP<schema>.usr02 set uflag=0 where mandt=<CLNT NO> and uflag=64;</b> this statement actually unlocks the users of that particular client. So, try for every client in that sap system.

b) You can delete sap* user

Go to cmd prompt.

Sqlplus /nolog

conn /as sysdba

sqlplus><b>DELETE SAP<SID>.usr02 where mandt='CLIENT.NO' and bname=SAP*;</b>

<b>Note:-

After doing this restart the system. So, that a new user with the name "sap" gets generated with password "pass". Provided the parameter is set login/no_automatic_user_sapstar= 0 (Automatic user SAP is permitted).</b>

regards,

kanthi

[Former Member]

Hi Shailesh,

I could not find the table USR02 in my SID or Master database. Hope i am not doing any mistake. FYI, my DATABASE is MS SQL 2005.

Thanks and Regards,

Rahul

[Former Member]

Hi Rahul,

For any db, you should have table usr02. Because, this stores all the user information.

Do one thing. you have to specify your schema user also to access your table.

Execute the following commands,

select <schemauser>.bname from usr02 where mandt=<client no.>;

delete from <schemauser>.usr02 where mandt=<client no.> and bname='sap*';

your schema user would be something like SAPR3 or SAPSR3 or such kind.

Thanks and Regards,

Sailesh K

[Former Member]

Hi Shailesh,

Thanks for your intiative, I saw in the back end, but i coundn't find any user with name SAP* in MS SQL, I am using MS SQL 2005.

How the SAP R/3 users are stored in the Database?

1) In Tables, In case its in table then

what is the table name?

2) As SQL user ? As i can not see any SAP* user in the SQL

Thanks and Regards,

Rahul

[Former Member]

Hi Rahul,

First connect to your database as sysdba. Then, use the following commands.

select bname from usr02 where mandt=<client no.>;

This command gives you a list of users in sap. Then,

delete from usr02 where mandt=<client no.> and bname='sap*';

This command deletes sap* user from database. Once its deleted, sap* will be used from the kernel with the password as pass.

Then, you can login with sap* and pass combination.

Try this, if you need help, please let me know.

Thanks and Regards,

Sailesh K

[praveenkumar_kadi]

To change the J2EE Engine administrator password in the secure store as follows:

1. Start the Config Tool by executing the /usr/sap/<SID>/<Instance name>/j2ee/configtool/configtool script file.

2. Select secure store.

3. Select the admin/password/<SID> entry.

4. Enter the J2EE Engine administrator user new password in the Value field and choose Add.

5. Choose File -> Apply to save the data.

6. Restart the J2EE Engine

The Note 669848 - Unlocking the Administrator User on the SAP J2EE Engine will help you guiding in all the steps.

SAP licence renewal procedure -- visit

======================

Hope that helps

[Former Member]

Hi Rahul,

You can use command saplicense.

'saplicense -show' gives you the current situation of the license;

'saplicense -get' gives you the hardware key, which you can use to apply a new license;

'saplicense -install' is the way you install the license in command line.

So you do not have to login the SAP system to install the license.

Regards

[Former Member]

Hi

Test your license

http://help.sap.com/saphelp_nw04/helpdata/en/67/4c8838c04b275de10000009b38f8cf/frameset.htm

regards

krishna

[Former Member]

Hi,

Delete SAP* user manually from the database using sql command for the particular client.

Then, try to login with sap* and pass combination. It will work.

Hope this helps.

Thanks and Regards,

Sailesh K