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

[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

[Former Member]

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".

[Former Member]

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

[Former Member]

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