Skip to Content
0

SAP HANA Express Edition Database Master Password issue

Aug 03, 2017 at 05:10 AM

243

avatar image

Hi,

I have downloaded HANA Express Edition 2.0 SPS 1. I have changed hxehost password successfully but then it is asking me to change HANA Master DB password. I believe this is nothing but SYSTEM user password as mentioned in its pdf documentation as well. Howvere when im changing this password im getting error:

I putting new password as alphanumeric with combination of lower and caps as well.

Anybody faced same issue please advise.

Thank you

he-error.png (55.8 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Frank Schuler
Aug 03, 2017 at 06:04 AM
0

Hello Sudhanshu,

From your screenshot it seems that the password has been successfully changed for the SystemDB and XSA, but that there was an error starting the tenant database HXE, i.e. there is nothing wrong with your password.

Therefore, please log into the HANA Cockpit and ensure that the tenant database HXE is started. Then change the SYSTEM password of that database, e.g. from HANA Studio.

Very best regards

Frank

Show 7 Share
10 |10000 characters needed characters left characters exceeded

Thanks Frank !

Problem is every time im logging into XSA console it is asking me to change Master DB Password. Its like: im logging with hxeadm user successfully but then it is asking me to change Master DB password every time.

'Getting Started' document says:

Now, when im trying above command its giving me 'Password Mismatch' error. However i can see XSC screen successfully.

Thanks

hex2.png (15.6 kB)
0

Hello Sudhanshu,

Please try to set the XSA_ADMIN passowrd from HANA Studio.

Best regards

Frank

0

Problem is, how could i login to studio unless i changed atleast SYSTEM user password. SAP document says that 'Master DB password' and SYSTEM user passwords are same but it is not allowing me to change it.

0

Problem is, how could i login to studio unless i changed atleast SYSTEM user password. SAP document says that 'Master DB password' and SYSTEM user password are same but it is not allowing me to change it.

which id should i use to login to studio.

0

Hello Frank,

problem is that it is not allowing me to change SYSTEM or Master DB password so which Id should i use to login to Studio.

Thanks

0

Hello Frank,

problem is that it is not allowing me to change SYSTEM or Master DB password so which Id should i use to login to Studio.

Thanks

0

Hello Frank,

problem is that it is not allowing me to change SYSTEM or Master DB password so which Id should i use to login to Studio.

Thanks

0
avatar image
Former Member
Aug 03, 2017 at 08:10 PM
0

Hi Sudhanshu,

This might be the case where the system is starting up and same time the hdb sql kicked in trying to change the password. Could you please logout and log back in as hxeadm. The init script reruns and should be able to update the password successfully this time. Please make sure to give the same password you have provided before. Please let us know incase of any further issues.

Thanks,

Vidya

Show 1 Share
10 |10000 characters needed characters left characters exceeded

hello Vidya,

when i'm logging back, it is asking me to change pw again and even if i'm putting the same pw i'm getting the same error.

Thanks

0