HANA Express Edition - Can not connect with SYSTEM user

[former_member188228]

Just installed HXE using VmPlayer on my Windows laptop.

Upon first login, a script runs to change the password for the system user (hxeadm) as well as master password for the database.

Database startup seems to be going fine. However, when I try to connect to the database (still at the vm prompt) I am getting an error.

hxehost: hxeadm> hdbsql -u SYSTEM -d SystemDB -p xxxxxxx

* -10709: Connection failed (RTE: [89006] System call 'connect' failed, rc=111:Connection refused (localhost:30013))

Connecting using Eclipse from Windows host is also failing.

[pfefferf]

What version of HXE you are using? 1 or 2?

[JohnNeil]

I have same problem even after modifying input.

hxehost:hxeadm> hdbsql -i 90 -d SystemDB -u SYSTEM

Password: xxxxxxxx

* 10: authentication failed SQLSTATE: 28000

[Former Member]

HXE 2.0 default instance is 90. Please try:

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

[former_member188228]

Thanks. That did the trick.

[JohnNeil]

Another "former member" provided a solution that worked for me

If there is problem with password of user SYSTEM, then you can change this in VM-Console with user

hxehost:hxeadm> hdbsql -n hxehost -i 90 -u SYSTEM -p"NewPW001"

Response was Welcome to the SAP HANA Database interactive terminal.

🙂