How to change the password of ddic in 000,sap* user is disabled

[Former Member]

Hi

SAP* user is disabled in 000 client in my production server,I can't enable it as it will require outage which is not possible now

I want to use ddic user to login in 000 but I forgot the password,is there any query to change the password for ddic user.My database is SQL server 2005

Rohit

[Former Member]

Hi,

Better to activate SAP* user instead of trying for the DDIC user .

Either use the Query Delete from usr02.sapr3 where bname = 'SAP*' and mandt = '000' or delete the

user SAP* from USR02 table where mandt value is 000 through SQL Visual Studio .

Check the value login/no_automatic_user_sapstar in RZ11 , if it is zero , no need to restart the instance .

Otherwise change it to 0 , restart the instance.

Now you will be able to login with the password pass.

Regards,

Nibu

[former_member204746]

what version is your SAP system? There is a trick you can use with older 4.7 or below systems.

[Former Member]

Hi

You can also try check these links

http://www.sap-img.com/basis/changing-the-default-password-for-sap-user.htm

http://www.sap-basis-abap.com/bc/forgot-password-for-user-id-sap-in-client-000.htm

Regards

Uday

[JPReyes]

If you don't have any other logon into 000 you might have to delete sap* via SQL statement and then logon with password PASS in order to reset DDIC password.

Delete from usr02.sapr3 where bname = 'SAP*' and mandt = '000';

You also need to check parameter login/no_automatic_user_sapstar is set to 0 so you can logon as SAP* password pass

Always change login/no_automatic_user_sapstar back to 1 when you're done.

Unfortunately you'll need a system restart to enable and disable the parameter

regards

Juan