cancel
Showing results for 
Search instead for 
Did you mean: 

Can't change SYSTEM password

Former Member
0 Kudos

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.

http://help.sap.com/saphelp_hanaplatform/helpdata/en/df/025d7abb5710148ba8b0ed6476b597/content.htm?f...

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?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

former_member183326
Active Contributor
0 Kudos

Hello,

Good to hear it's solved.

Please close this thread off.

Answers (3)

Answers (3)

Former Member
0 Kudos

How do I close this off?

anandtigadikar
Employee
Employee
0 Kudos

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

former_member183326
Active Contributor
0 Kudos

Reset the SYSTEM User's Password - SAP HANA Administration Guide - SAP Library

Read the opening statement, they have followed this guide Already.

former_member183326
Active Contributor
0 Kudos

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?

  1. Reset the Hdbuserstore:

>hdbuserstore DELETE DEFAULT> hdbuserstore SET DEFAULT <new DC hostname><port> ; <hdb/schema> <PASSWORD>

  1. When the hdbuserstore key is set to DEFAULT it means that it is used by the NetWeaver work processes to connect to the HANA database. Ensure that the user maintained in hdbuserstore is SAP<SID>.
  2. Check to see that the hdbuserstore files are correctly redistributed and are also maintained in the HANA host.