Skip to Content
avatar image
Former Member

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Nov 15, 2016 at 10:03 PM

    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!

    Add comment
    10|10000 characters needed characters exceeded