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]

License Issue:

Logon to the OS where SAP installed. Change to ...\run\exe

run:

saplicense -get (it will show you the hardware key)

saplicense -install (it will allow you to install the license).

Logon Issue:

once the lincense is installed logon throug DDIC.

[Former Member]

Hi ,

<b>If all the users are locked, they can be unlocked by</b>

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 Sreevidya,

My backend is MS SQL not oracle, you have any idea, how can i do that in my MS SQL 2005 database, what is the table name where users get stored??

[Former Member]

Table Name is <b>USER02</b> change the valu from 0 to 1

run transaction ST02 to clear the buffer

Reward pts if helpful

Regards

Swapnil

[Former Member]

Dear Swapnil,

he is not able to logon to server itself , so how can he run st02.

Regards,

[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

[Former Member]

hi,

You can also delete SAP* user in client 000. It will default its password to PASS.

In SQL

SELECT * FROM USR02 WHERE BNAME='SAP*' AND MANDT='000'

Run query to check return. Change Select to Delete and run again.

1. Reset the password of 'sap*' in client 000

2. Log on to oracle database using sqlplus.

sqlplus / nolog

SQL>connect /as sysdba

SQL>update <SchemaOwner>.USR01 set bname='SAP1' where bname='SAP' and MANDT=000;

1. [ e.g.: update SAPR3.USR01 set bname='SAP1' where bname='SAP' and MANDT=000; ]

2. [e.g. : update SAP<SID>.USR01 set bname='SAP1' where bname='SAP' and MANDT=000;]

SQL>commit;

SQL>exit

1. This will reset the user SAP* in client 000 . After loggin in client with user SAP* change the passwords for other users.

1. You can user client number of your respective client.

<b>## Please note do not reset any other user than SAP* with this method. </b>

Reward points if useful.

Regards,

Sreevidya.S