Hostname change -> db_connect failed, unknown host name, Return Code 000256

[szymon_bolek]

hullo!

System: Windows XP SP2

AS: NW ABAP 7.01 Trial Version

I have a problem after changing a host name. I changed it as follows:

I stopped the NW AS.

Changed etc/hosts file.

Changed the IP address.

Renamed host under "My Computer".

Changed all occurences of <old host name> to <my new host name> in the registry.

Restarted the system.

When starting the AS in the console the following error occur:

File C:SAPNSPDVEBMGS00workdev_w0

Database error -10709 Connection failed (RTE:unknown host name)

Syslog says: "DB-Connect Failed, Return Code 000256"

I followed this BLOG

[https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/3116] [original link is broken] [original link is broken] [original link is broken];

and check the OSS Note: 39439 - XUSER entries for SAP DB 6.x and 7.x

and as it stated maintained the users(USERKEY/USERID):

DEFAULT/SAPNSP

c/CONTROL

w/SUPERDBA

domain/DOMAIN

NSP/SAPNSP

However with my new hostname I ended up with the same error mentioned above while starting disp+work.exe

In the BLOG there is a workaround which works for me, but it does not solve the problem.

Does anyone have a clue what I might have done wrong? I would be grateful.

thanks+best regards

simon

[siarhei_pisarenka3]

Hi Simon

Run Config Tool and change DB connection settings there in Secure Store. Update admin/host & jdbc/Url properties wherever you find the old host name. Then save the changes and restart the cluster.

BR, Sergei

[szymon_bolek]

Hi Sergei, Hi Manoj,

Thanks, I will check both your suggestions and let you know what happened. However where will I find the config tool under NW ABAP, I did not know it existed there.

best regards

simon:)

[Former Member]

check SAP Note 403708 - Changing an IP address and make sure there are no space, special characters in the hostname.