Skip to Content
avatar image
Former Member

Wrong password System

Hello,

I've just finished the Conversion to Multitenant Database Containter. After that I've tried to define SYSTEMDB connection into Hana Studio, but I can't define it because the username or password are wrong. I've checked several times and It was correct.

I've reset the system password using help.sap Resetting the SYSTEM User Password in Multitenant Database Containers but I'm getting the same problem.

What can I try?

Invalid.JPG (21.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 16, 2015 at 12:24 AM

    Hi Ruben,

    Make sure that you connected to the SYSTEM DB.

    You can also try to connect to SYSTEM DB with hdbsql:

    hdbsql -i <instance_number> -n <host>:<port> -d SystemDB -u SYSTEM

    Then you will be asked to change the password for user system of SYSTEM DB again according to the default password policy (although you have reset the password with command hdbnameserver –resetUserSystem).

    Regards,

    Ning Tong

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Tong Ning


      Hello Tong,

      I've tried too but I get this error:

      SAP:/usr/sap/D00/HDB00/exe> ./hdbsql -i 00 -n SAP:30013 -d SystemDB -u SYSTEM

      Password:

      * 10: authentication failed SQLSTATE: 28000

      SAP:/usr/sap/D00/HDB00/exe>

      Regards

      I´ve used the solution from thread

      [password policy]

      password_lock_for_system_user = false

  • avatar image
    Former Member
    Oct 15, 2015 at 05:34 PM

    Hi Ruben,

    The password for user SYSTEM after Multitenant conversion remains the same as it was on a Single container instance

    SPS10 Administration guide confirms this as well

    I notice some thing interesting in your screenshot the user name appears as *System* instead of *SYSTEM* in UPPER CASE

    Is that some thing you can check as SAP HANA Studio accepts SYSTEM in uppercase and it is case sensitive

    Please check and let me know

    Sunil

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Sunil,

      On Hana Studio, appears the SYSTEM user in upper case.

      The password includes an upper case letter.