on 10-15-2015 5:40 PM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.