HANA Express Edition - 28000 Password already changed

[yolcar]

Cuando inicio la VM de HANA EXPRESS, comienza el proceso de instalacion, luego se detiene con el siguiente error.

* 10: authentication failed SQLSTATE: 28000 Password already changed. However, the new password you specifies is invalid.

Imagen Error

Este error sucede tanto usando VMWare o VirtualBox, probado con la siguientes RAM 12 GB(Default), 24 GB, 40GB

[dvankempen · Accepted solution]

Hi Yolcar,

On the VM, the XSA_DEV and XSA_ADMIN accounts in the system database are locked as a result of the default SAP HANA password policy (maximum_password_lifetime = 182); probably the same issue on the docker image.

The system account is excluded from this policy, so you can perform the reset using SQL.

While at it, you may also want to reset the self-signed certificate (expires after one year).

HDB start
XSA reset-certificate
 
hdbsql -u system -n hxehost:39013
alter user XSA_ADMIN activate user now;
alter user XSA_ADMIN password <new password>;
alter user XSA_DEV activate user now; 
alter user XSA_DEV password <new password>; 

A similar issue was reported today regarding the Docker image

• https://answers.sap.com/questions/13319390/issue-running-docker-image-storesaplabshanaexpress.html

[yolcar · Accepted solution]

Muchas gracias, ahora si avanzo la instalacion sin problemas.

[dvankempen · Accepted solution]

Muy bien. Gracias por confirmar.