cancel
Showing results for 
Search instead for 
Did you mean: 

Wrong password System

Former Member
0 Kudos
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?

Accepted Solutions (1)

Accepted Solutions (1)

former_member182967
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hello Tong,

I´ve tried to execute the command but I can't connect

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

Password:

* -10709: Connection failed (RTE:[89006] System call 'connect' failed, rc=111:Connection refused)

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

The password is correct because y reset the password again and I've checked it

What can I try?

Regards

former_member182967
Active Contributor
0 Kudos

Hello ruben,

Sorry, I forget to tell you the port for SYSTEM DB connection

> hdbsql -i <instance_number> -n <hostname>:3<instance_number>13 -d SystemDB -u SYSTEM

Regards,

Ning Tong

Former Member
0 Kudos


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

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hello Sunil,

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

The password includes an upper case letter.