Netweaver IDES install check DDIC ID for client 001 failed

[Former Member]

The installation procedure on step 29 to Check DDIC Password failed.

The instance was started, we are able to login to client 000 with SAP, DDIC user ID with default password, but not on client 001, both SAP and DDIC not able to login with default password.

Tried update the system profile, added following entry:

login/no_automatic_user_sapstar = 0

restarted the system

and do the following steps to delete the SAP* on client 001, but hit error.

Started the SQLPLUS "/as sysdba"

DELETE SAPSR3DB.USR02 WHERE MANDT='001' AND BNAME='SAP*';

table or view does not exist

Pls help.

[Former Member · Accepted solution]

It worked. Thanks.

[Former Member · Accepted solution]

Please award suitably.

reg, Dibya

[Former Member]

hello

try this

1. Open SQL server management studio

2. Login

3. Expand the database node

4. Click your specific database and click "New Query"

e.g ->DELETE FROM <sid>.USR02

WHERE BNAME='SAP*' AND MANDT='<client no.>'

==================

DELETE FROM fld.USR02

WHERE BNAME='DDIC' AND MANDT='100'

After you run the script successfully, you can now log on that client using DDIC and password = pass

BR,

krishnamurthy .k

[Former Member]

Hi,

Do not use the schema name as SAPSR3DB as this is the JAVA schema. Just use SAPSR3 and it will work.

DELETE SAPSR3.USR02 WHERE MANDT='001' AND BNAME='SAP*';

Then you should be able to login via SAP*/pass

Regards, Dibya