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
592

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
Gavin_G
Participant

Hi @mmshareef 

For SAP*:

- login/no_automatic_user_sapstar must be set to 0

- there must be no sap* user record to use the default password - if there is you need to know the password assigned to the sap* user

Some useful links on the subject

Note 2383 - Documentation: description of "super user" SAP* 

Note 68048 - Deactivating the automatic SAP* user 

Activating Automatic sap* user 

Profile Parameters for Logon and Password (Login Parameters) 

 

I hope this helps

 

Gavin

Sandra_Rossi
Active Contributor
0 Kudos
So, this solution requires to delete the SAP* user, which leads to the latest situation (Sybase authorization to run an SQL statement).
Gavin_G
Participant
0 Kudos

@Sandra_Rossi,

login/no_automatic_user_sapstar need to be disabled to log in as sap*

If a sap* user was created manually then that password is required to log in - the default password will not work

 

The SQL error is due to the the user executing the SQL command  not having sufficient permission at the database level - it's not SAP related

mmshareef
Explorer
0 Kudos
Hello Gavin , thank you for your support once again , unfortunetly i can see the provided solution is for SQL here i have SYBASE DB
Gavin_G
Participant
0 Kudos

Hi @mmshareef 

 

The link @S_Sriram supplied is comprehensive and the sql is not database dependent. All that will change is the tool you use to connect to the database to run the sql. There should be a Sybase command line utility to connect to the database for this scenario.

 

The actions you need to take

  • check the SAP parameter is set correctly. A restart of SAP  is required for it to take effect 
  • use sql to check DDIC is not locked - you need to use a user with access to your SAP schema
  • OR remove the sap* user so that you can use the default sap* password 

 

Perhaps it is appropriate to mention that under normal circumstances you shouldn’t directly update n SAP database.

 

Gavin