Skip to Content
0

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

Nov 12, 2016 at 10:11 AM

216

avatar image

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

ympu5.png (24.0 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Mary Qi
Nov 15, 2016 at 10:03 PM
0

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!

Share
10 |10000 characters needed characters left characters exceeded