Skip to Content

HANA Express 2.0 Change the Default Password for SYSTEM User

Dec 11, 2016 at 09:20 AM


avatar image

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,


error.png (30.2 kB)
10 |10000 characters needed characters left characters exceeded

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.

* Please Login or Register to Answer, Follow or Comment.

6 Answers

Carlos Pinto Mar 13, 2017 at 11:49 AM

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,


Show 2 Share
10 |10000 characters needed characters left characters exceeded

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


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.

Will Conlon Dec 11, 2016 at 11:07 PM

I was using the command incorrectly. Correct command is:

hdbsql -i 90 -d SystemDB -u SYSTEM -p HXEHana1

10 |10000 characters needed characters left characters exceeded
Yi qing Ling
Jan 16, 2017 at 07:20 PM


For system password, the procedure to change password is a little different. Please see the following link:

For other users, you should be able to use the following command after your login as SYSTEM user with hdbsql:

ALTER USER <user> PASSWORD "<new password>"



10 |10000 characters needed characters left characters exceeded
Anwar ul haque Jan 12, 2017 at 05:07 PM


I do have the same issue. I am also unable to resolve it.

Though according to SAP documentation,

User need not to change passwords. I think only some expert can give advice.

sapexpress.png (41.6 kB)
10 |10000 characters needed characters left characters exceeded
Amit Mahapatra Jan 15, 2017 at 03:45 AM

i am also facing the same issue..not able to change the SYSTEM password but getting a strange message

*10: authentication failed SQLSTATE: 28000

i don't know what does this mean and how to solve this..

10 |10000 characters needed characters left characters exceeded
Will Conlon Mar 01, 2017 at 08:15 AM

As a point of note, the documentation has changed somewhat since I posted this thread several months ago and it seems documentation around changing initial passwords for SYSTEM, XSA_ADMIN, XSA_DEV and XSA_SHINE have been removed.

Use: 'hdbsql -i 90 -d SystemDB -u <USER> -p HXEHana1' to prompt a change when initially using these users.

10 |10000 characters needed characters left characters exceeded