Skip to Content

HANA express, XSA_ADMIN authentication failed

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!


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Nov 26, 2017 at 08:30 PM

    Hi, Johannes,

    Can you try logging in with the default password instead? It's A5pl1ance

    How many times did you try to change the password using "alter user..."?

    Thanks,

    Lucia.


    Add comment
    10|10000 characters needed characters exceeded

  • Nov 27, 2017 at 08:31 PM

    Hi Lucia,

    Thanks for your response! The default password didn't work either. Nevermind. I set up a new HANA express CAL instance and now everything is fine so far. Perhaps I didn't wait enough time (10 minutes) after activating the suspended instance and something got screwed up?!

    By the way, I am very impressed about all the tutorials, videos, and the community itselft around HANA!

    Kind regards,

    Johannes.

    Add comment
    10|10000 characters needed characters exceeded

  • May 30 at 09:38 AM

    Hi,

    I'm facing the same issue here. After 2weeks of not using the instance, when I wanted to get back at it now I couldn't and i'm pretty sure of my password !

    Basma

    Add comment
    10|10000 characters needed characters exceeded