cancel
Showing results for 
Search instead for 
Did you mean: 

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

mmshareef
Explorer
0 Kudos
579

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
Active Contributor
0 Kudos
Can you connect with SAP* or DDIC in client 000? What user did you use in client 000?
Sandra_Rossi
Active Contributor
0 Kudos
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).
View Entire Topic
mmshareef
Explorer
0 Kudos

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

 

mmshareef
Explorer
0 Kudos
(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
Active Contributor
0 Kudos
Hi Shareef, try to logon SIDADM or DB admin userid
Sandra_Rossi
Active Contributor
0 Kudos
The error message says "owner SAPSR3" so if you login with database user SAPSR3 it should work (isql -USAPSR3 -SNPL -X)
Sandra_Rossi
Active Contributor
0 Kudos
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....