Trying SAP Hana Express edition, cannot change default passwords on SystemDB

[Former Member]

Hello,

after downloading and importing hxesa.ova into VMWare Workstation 12.5.1 build 4542065 I am able to start the VM, login as user hxeadm and change the user's passwort, but I cannot change the default passwort for the SYSTEM user on the SystemDB (see screenshot attached). The services seem to be fine, but those two sql syntax errors seem to prevent that the password gets actually changed.

Any idea what's going wrong here?

Best regards,

Thomas

[Former Member]

Hello Thomas,

Could you try changing the password directly using the alter password command:

hdbsql -u system -p HXEHana1 -d SystemDB "alter user system password <your new password>"

Then hit return a couple of times until you get the prompt back.

Please let me know if that doesn't solve the problem. Thank you!