"Check DDIC password" error

[Former Member]

when i was presented with the screen of DDIC password, i wrote the wrong one, so i now i have a mess with my passwords.

I can access to the 000 client with SAP* and DDIC, the both of them are reseted to the default passwords, but i can't log on to the 001 client, the both users (SAP* and DDIC) are locked, so i can't enter the sistem to reset them.

Anyway, now i restart the installation and have this error:

"Test logon to SAP System ALH failed.

Make sure that the system is started, that the user DDIC exists and that the password of user DDIC is correct."

The sistem is running, both cients are in green!

I tried to run the reports RSWBOINS and RADDBDIF as some guys on thi forum suggested, but no luck

Any ideas??

[Former Member · Accepted solution]

What db are you using?

[Former Member · Accepted solution]

Doing the search it's all i'm doing!! But may be i'm looking in other direction.

I managed to delete the SAP* user for 001, from the table USR02 of my MaxDB through SQL Studio.

I then tried to log on to the 001 Client with passwords "PASS", "pass" and "06071992" , but no luck...

i tried to restart the SAP Installation, but it stops at the same step "DDIC check"

[former_member204746 · Accepted solution]

search for SAP parameter login/no_automatic_user_sapstar

it must be set to "0" and SAP system restarted.

[Former Member · Accepted solution]

I don't know if I misunderstood you, but if you delete the user SAP* from USR02, you will not be able to login using that user id.

From the DB server logged in as <sid>adm, run the script below.

sqlcli -U DEFAULT "select * from usr02 where bname='SAP*'"

[Former Member · Accepted solution]

Jared, Eric, Ravi, thank you guys!!

On the database level i unlocked the uder DDIC making UFLAG=0

and on the other hand i what Eric said and the user log on profile in my SAP instance to 0 and thus i finally was able to log on with SAP* password.

ABAP Report phase went fine but now i have stoped in a "Change default passwords"

But im gonna open another post since i have no more point to give you!!

[Former Member]

Go to database level and reset the password for SAP* for client 001

update <DB schema>.USR02 set UFLAG = 0 where MANDT = <client number> and BNAME = u2018SAP*u2019;

With the above query you can unlock SAP* and if you know the password you are able to logon to that client.

if still you do not able to logon to that client

delete the User SAP* with below query

delete from <DB schema>.USR02 where bname like 'SAP*' and MANDT like '001'

than you can able to logon to that client with SAP* and use default password "pass".

after that you can change the password for DDIC from SU01.

This will help you.

[former_member204746]

Ravi, there is are a few steps missing...

Kuatroka, please search SDN.

[former_member204746]

use SDN search engine with these keywords:

SAP* password reset

or

DDIC password reset.

if this does not work, restart installation from scratch and this time, remember the password.