Skip to Content
-1

error my sap hana studio not connecting with hana server SYSTEM user

Jun 10, 2017 at 10:56 AM

97

avatar image
Former Member

error-my-studio-not-connecting-with-hana-server-sy.jpgPlease, what can I do to be able to log into SYSTEM user as database user in eclipse.

While I was installing the Sap Hana express VM image in SUSE server, at the stage when i needed to change the SYSTEM user password, I issued

the command -u SYSTEM -d SystemDB -p HXEHana1 at the command prompt hxehost:hxeadm? in order to get a prompt

to change the password, but it did not work.



Thanks for your support in anticipation



Abraham

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

avatar image
Former Member
Jun 12, 2017 at 03:44 PM
0

Hi Abraham,

You should also provide instance number when you login. Can you try add "-i < instance number>" to see if it works?

Thanks!

Yiqing

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jun 12, 2017 at 03:59 PM
0

Hi,

use alternative way:

1. stop database ./HDB stop

2. start nameserver in background: hdbnameserver &

3.start compile server in background: hdbcompileserver &

4.And the run this command: hdbindexserver -resetUserSystem

provide new password and then restart HANA.

it should help



Share
10 |10000 characters needed characters left characters exceeded
Tai Le
Jun 13, 2017 at 04:39 PM
0

Hi Abraham,

Which HXE version are you using? When you login to the VM the first time, it should have prompted you new master password for HDB. Use this new password to login to HDB.

1) Please check if you can access the VM from the machine where you run HANA Studio. Run "ping <VM IP address>".

2) HXE has default instance number 90. Please specify this in hdbsql command (-i 90).

3) The command in last captured screen is a typo. You need to specify "hdbsql".

Share
10 |10000 characters needed characters left characters exceeded