HANA Express 2.0 Change the Default Password for SYSTEM User

[Former Member]

Hello Team,

HANA Express Edition 2.0 SP00 server + apps. VMWare Player running on Windows 10, hosting SUSE12 guest.

I've been having issues changing the default password for SYSTEM, XSA_ADMIN and XSA_DEV. The error received is a Connection Refused on localhost as per screenshots. I've checked many SAP and non-SAP articles related to this issue. I've tried with several users and also tried to directly ALTER the password but without success.

No firewall running on the guest and i've disabled the firewall on my local machine to test.

I've also modified the hosts file in System32 drivers. I can see XSA running through browser on port 8090....

One thing i have noticed is the guest not showing up on my router.

Specific error message: * -10709: Connection failed (RTE:[89006] System call 'connect' failed, rc=111:Connection refused (localhost:30015).

Can someone kindly nudge me in right direction?

Thank you,

Will

[Former Member]

If you install the VMware Image you have to change the passwort for hxeadm and for XSA_DEV users.
Ich changed this and the passwords for this user work. I never changed the password for teh system user.

Which password ist defined for system user after installation? HXEHana1 doesn't work and cd password for

hxeadm and XSA_DEV do not work for the system user.

[carlospinto · Accepted solution]

Hi Will,

With your permission, I would like to add a method to reset system user password that I found in the next video tutorial (not easy to find from this community):

SAP HANA Academy - SAP HANA Express: Security: Reset SYSTEM user password

It is only 5 steps and it worked for me after an "authentication failed sqlstate: 28000" error.

The commands are the following:

1. su – hxeadm (hxeadm = operating system administrator)
2. HDB stop
3. hdbnameserver -resetUserSystem
4. resetting of user SYSTEM – new password: (provide new password)
5. HDB start

Thank you,

Carlos

[former_member442740 · Accepted solution]

Carlos, you are life saver. It works. Thanks so much

[Former Member · Accepted solution]

I wasn't able to access the SystemDB to perform an upgrade and this solved the issue. I assume the SystemDB password got misaligned when I changed the SYSTEM password from Eclipse.