I am unable to log in with SAP* or DDIC user passwords

[mmshareef]

I have created a new client (787) and performed a local client copy from client 000 using the profile SAP_ALL. After the copy was completed, I am unable to log in with SAP* or DDIC user passwords. Could anyone please guide me through resolving this issue?

I am new to SAP BASIS, and we are running on Windows ECC 6.0 with Sybase DB.

Any help would be appreciated!

Faiyaz

[Sandra_Rossi]

Can you connect with SAP* or DDIC in client 000? What user did you use in client 000?

[Sandra_Rossi]

Log in with the same user as the one you have used in 000 (SAP_ALL copies all user master data and roles, including passwords).

[mmshareef]

No , i cannot login to 000 as well , it says too many failed attempts

[S_Sriram]

Hi Shareef, Check this thread, https://community.sap.com/t5/technology-q-a/how-to-unlock-ddic-sap-user-in-000-client-sybase-databas...

[mmshareef]

(1 row affected) 1> Select top 1 * from SAPSR3.USR02 2> go Msg 10330, Level 14, State 1: Server 'AJD', Line 1: SELECT permission denied on object USR02, database AJD, owner SAPSR3 1> Select * from SAPSR3.USR02 where BNAME=’SAP*’ 2> go Msg 10330, Level 14, State 1: Server 'AJD', Line 1: SELECT permission denied on object USR02, database AJD, owner SAPSR3 1> use master 2> go 1> sp_db_name() 2> go Msg 102, Level 15, State 181: Server 'AJD', Line 1: Incorrect syntax near ')'. 1> select db_name() 2> go ------------------------------ master (1 row affected) 1> select db_name() 2> go ------------------------------ master (1 row affected) 1> use AJD 2> go 1> select db_name() 2> go ------------------------------ AJD (1 row affected) 1> select top 1 * from SAPSR3.USR02 2> go Msg 10330, Level 14, State 1: Server 'AJD', Line 1: SELECT permission denied on object USR02, database AJD, owner SAPSR3

[S_Sriram]

Hi Shareef, try to logon SIDADM or DB admin userid

[Sandra_Rossi]

The error message says "owner SAPSR3" so if you login with database user SAPSR3 it should work (isql -USAPSR3 -SNPL -X)

[Sandra_Rossi]

I just tried the link given by @S_Sriram on my ABAP/Sybase system, it works well. What is your issue? Also the same answer here: https://community.sap.com/t5/technology-blogs-by-members/how-to-unlock-users-using-sql-console-on-sa....