on 06-23-2016 5:30 PM
I have a free AWS Amazon trial of SAP HANA developers edition.
I'm seeing this...
The free trial came with Cockpit and I was able to set my SYSTEM password there, but I'm still seeing...
sid-hdb:/usr/sap/HDB/HDB00> hdbsql -n localhost -i 00 -u SYSTEM
Password:
* 10: authentication failed SQLSTATE: 28000
sid-hdb:/usr/sap/HDB/HDB00>
Then I try to reset the password using these instructions, still can't do it.
nameserver vhcalhdbdb:30001 not responding. retry in 5 sec...
nameserver vhcalhdbdb:30001 not responding. retry in 5 sec...
nameserver vhcalhdbdb:30001 not responding. retry in 5 sec...
nameserver vhcalhdbdb:30001 not responding. retry in 5 sec...
nameserver vhcalhdbdb:30001 not responding. retry in 5 sec...
I ultimately want to connect to SAP HANA via JDBC, but I can't seem to get the SYSTEM database account working. Does Cockpit not handle this on the database side?
I got it working actually. I had to frankenstein some steps in order to get the reset working.
[password policy]
password_lock_for_system_user=false
The above was already set, find that during my research and nameserver is up.
But it finally accepted my reset command and connection via JDBC worked.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
How do I close this off?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Which HANA DB version are you trying to do this??
For V85.03 and below--
http://scn.sap.com/docs/DOC-33097
For anything latest, try to follow below link
http://help.sap.com/saphelp_hanaplatform/helpdata/en/df/025d7abb5710148ba8b0ed6476b597/content.htm
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Reset the SYSTEM User's Password - SAP HANA Administration Guide - SAP Library
Read the opening statement, they have followed this guide Already.
Hello,
Here are some ideas:
The SYSTEM password may be locked: Try changing the indexserver.ini parameter:
usr/sap/<systemname>/SYS/global/hdb/custom/config:
[password policy]
password_lock_for_system_user=false
The above also says your nameserver is not responding, is it down?
When you say you are trying to connect SAP HANA via JDBC, have you tried resetting the hdbuserstore key?
>hdbuserstore DELETE DEFAULT> hdbuserstore SET DEFAULT <new DC hostname><port> ; <hdb/schema> <PASSWORD>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.