Error Connect to database failed : sqlcode=-4008 in dev_w0

[Former Member]

Hi all,

I have a testing ABAP ECC5 system (in Windows 2003, MaxDB 7.6 build 35).

After changing default passwords of DB users SAP<SID>, CONTROL, SUPERDBA using DBMGUI, I then run commands below to update new passwords in XUSER entries (according to SAP Note 39439):

- xuser -U DEFAULT -u SAP<SID>,<password> -d <database_name> -n <database_server> -S SAPR3 -t 0 -I 0 set

- xuser -U c -u CONTROL,<password> -d <database_name> -n <database_server> -S INTERNAL set

- xuser -U w -u SUPERDBA,<password> -d <database_name> -n <database_server> -S INTERNAL set

The SAP system now cannot be started successfully. In dev_w0, there is info. like below:

"Connect to database failed : sqlcode=-4008 (Unknown user name/password combination)."

Command "r3trans -d" returns 0.

In SAP Note 39439 I see that maybe I should update info. for OS user SAPService<SID>. But I don't know what "..." means in command "xuser -c <domain>\SAPService<SID> ..."

I searched SAP SDN & SAP Notes, but still cannot fix this.

Please guide me to update XUSER entries after changing passwords of DB users.

Regards,

[markus_doehr2 · Accepted solution]

> I have a testing ABAP ECC5 system (in Windows 2003, MaxDB 7.6 build 35).

Just as additional info: your database version is ancient - I suggest upgrading to a newer release.

> In SAP Note 39439 I see that maybe I should update info. for OS user SAPService<SID>. But I don't know what "..." means in command "xuser -c <domain>\SAPService<SID> ..."

The SAP system runs under User SAPService<SID>, you're most likely logged on using <sid>adm, that's why your "R3trans -d" connect is successful.

You have to execute the same command for the entry DEFAULT also for user <DOMAIN>\SAPService<SID>, that's what the dots mean

Markus

[Former Member · Accepted solution]

Thank you.

The SAP Note does not mention running the entry DEFAULT under SAPService<SID>

Regards,