06-02-2007 1:21 AM
I have installed a demo version of SAP NW.
I have created client 100 in client 000.
My question is how do i login to client 100??
I tried SAP* with PASS but coudld not get into..
Any ideas??
06-02-2007 5:12 PM
Hi
Check your profile parameter is login/no_automatic_user_sapstar =0 If not you change it via T code RZ10.And if this alreday chang you go sql plus and delete sap* in table USR02.
when you restart system you login your system sap* password pass.
Thanks
Pankaj Kumar
06-02-2007 1:32 AM
06-02-2007 8:39 AM
Hi,
Set the profile parameter login/no_automatic_user_sapstar =0in rz10 TC and also refer the Note 937323
Please reward the points if useful
Regards,
Rakesh
06-02-2007 5:12 PM
Hi
Check your profile parameter is login/no_automatic_user_sapstar =0 If not you change it via T code RZ10.And if this alreday chang you go sql plus and delete sap* in table USR02.
when you restart system you login your system sap* password pass.
Thanks
Pankaj Kumar
06-02-2007 7:13 PM
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
06-02-2007 7:34 PM
06-04-2007 5:56 AM
Have you able to login to the system now with SAP* id ?
Once I faced the simliar kind of issue due to license problem.
06-04-2007 11:28 AM
Hi,
Do you have database level access?
If yes you can delete SAP* user. It will automatically get created. Follow these steps.
Logon to your database with orasid as user id and execute this sql
delete from sapSID.usr02 where bname='SAP*' and mandt='XXX';
commit;
(bname is user name & mandt is the client)
Now you can login to the client 100 using sap* and password pass
Thanks & Regards,
Sameer
06-04-2007 11:41 AM
Hi,
Have you done the client copy after creating the client 100? If not, do the following:
1) Log on to the new client with user: SAP* with the password: PASS.
2) Start transaction SCCL and copy the client 000 using the recommended profile SAP_ALL, SAP_USERS,SAP_CUST. This takes approximate. 45 minutes to complete.
Than in client 100 you can create your own UserID and start working on it.
Hope it helps.
Please award points if it is useful.
Thanks & Regards,
Santosh