Skip to Content
0
Nov 26, 2017 at 12:02 PM

HANA express, XSA_ADMIN authentication failed

2919 Views

I have setup the latest HANA express edition from SAP CAL, following Lsubatin's tutorial: Setup SAP HANA. I altered the password for user XSA_ADMIN with the following command in the SQL console:

hdbsql SYSTEMDB=> alter user XSA_ADMIN password HanaRocks10;

When I then login with the command-line tool xs and user XSA_ADMIN, authentication fails:

hxeadm@sid-hxe:/usr/sap/HXE/HDB90> xs login -a https://localhost:39030 --skip-ssl-validation -u XSA_ADMIN

API_URL: https://localhost:39030
The authenticity of host 'localhost' is not validated!
USERNAME: XSA_ADMIN
PASSWORD>
Authenticating...
Authentication failed: Name or password mismatch
See logs in /usr/sap/HXE/home/.xs_logs/xs_0.log for details.

I am for sure using the password 'HanaRocks10', I set before.

The xs_0.log file contains the following entry:

# XS command line client version: v1.0.63 (built 2017-07-19 09:39:47, codeline REL, SAP SE)
# Command line: xs login -a https://localhost:39030 --skip-ssl-validation -u XSA_ADMIN

[2017-11-26 11:40:49:008]-[CLI]-[error]-[.]-[.]: Authentication failed: Name or password mismatch
com.sap.xs2rt.client.exceptions.AuthException: Authentication failed: Name or password mismatch
        at com.sap.xs2rt.client.impl.operations.UaaOperations.login(UaaOperations.java:112)
        at com.sap.xs2rt.client.impl.command.Login.run(Login.java:272)
        at com.sap.xs2rt.client.impl.Main.main(Main.java:310)

I have checked out similar contributions in this forum. But I couldn't solve my problem. Do you have an idea? Any help would be very nice. Thank you!