Login Problem after Client Copy

[Former Member]

Hi Gurus,

Iam an ABAPer . i have made a client copy from 000 to 810.

after client copy iam not able to login into 810 with sap* / pass,

getting error message "USERID R PWD IS WRONG".after some hits

"USER IS LOCKED ".

iam not able to login with DDIC / 19920706 either into 810.

please help me to login into 810.

iam tired really after reading so many related posts / links from this forum.but i dont understand anything.pls answer patiently.

i have few more doubts.

in my system i have 000,001,066 clients.iam not able to login into any of these clients with either sap* r ddic. why?

is ther any tcode where i can see list of users with passwords for a particular client?

how to delete a client and how to delete all the data related to that client in database?

pls help me....

Satish.

[Former Member · Accepted solution]

HI Satish

You can reset the password for sap* client 810 in the following way.

1. Go to /usr/sap/sid/sys/profile/instance profile(dvegms00).

not dvegms00.bak.

2.Open it with notepad.

3 check for the the profile parameter

login/no_automatic_user_sapstar = 0

4. If it is not present then enter it manually in the instance profile which u have opened with notepad.

5. now shutdown sap from MMC

6. Restart SAP from MMC

7.now at os level. login to windows as <SIDADM>.

8.go to start-run-cmd and type sqlplus "/as sysdba"

9. after you are connected type the follwing commands....

- select bname from sapSID.usr02 where mandt = '810' and bname'SAP*';

10.delete from sapSID.usr02 where mandt = '000' and bname'SAP*';

- commit work;

11.Now you can open SAPGUI with client x... and login with SAP* and

password PASS

Your all set.

Assign points if it was useful

[Former Member · Accepted solution]

Hi gurus thanku for ur Response....its working.

thanx Bharani........bulls eye...........

can we delete a client from another client ?

if i deleted a client suppose 810 through scc5,it will delete all the database entries related to 810 ?

is sap*/pass and ddic users are automatically created when a client is created ?

thanx in advance Gurus...

Bye.

[Former Member]

Hi,

sap* and ddic user will be available once u create new client.

Regards,

Rohit Mehta

[Former Member]

Hi,

For client copy login to source client with t-code scc4 and create the new client. Provide the details for new clients.

check for the the profile parameter

login/no_automatic_user_sapstar = 0

login to destination client with sap* and p/w as pass.

run t-code sccl for local client copy with sap_all.

Kindly provide the points if issue solve.

Regards,

Rohit mehta

[Former Member]

Which profile did you use for the client copy? If you included the user data, then just log in with the same user passwords as those from the source client.

Hope that helps.

J. Haynes

[Former Member]

Hai,

Is the Client copy is completed successfully or not.

If it is successful,then you can login with the same userid and password as in client - 000.

If you are not able to login into client - 810 with sap* and PASS, then create a parameter in the Instance Profile -

login/no_automatic_user_sapstar and the value is 0 and restart the system to get it effected.

Once the restart is completed,you can login into client - 810(if the client copy is not completed) with sap* and PASS.

doubts-

in my system i have 000,001,066 clients.iam not able to login into any of these clients with either sap* r ddic. why?-->Check the passwords,which are given during the installation and use the same password for login into 000,001 and 066 clients.

is ther any tcode where i can see list of users with passwords for a particular client?--> You cant see any passwords,they will be in encrpyted format.

how to delete a client and how to delete all the data related to that client in database?--->

1. log into the client to delete

2. go into SCC5 and delete client

3. log into another client and delete entry with SCC4

4. reorg database to recover database space.

Actually, if you check "on" the little "Delete Entry from T000" checkbox, you can skip step 3.

Thanks and Regards,

[former_member185954]

Hello Satish,

You can check this thread to unlock SAP*

Regards,

Siddhesh

Edited by: Siddhesh Ghag on Apr 9, 2008 6:11 PM