Skip to Content
avatar image
-1
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

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

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 12, 2017 at 03:59 PM

    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



    Add comment
    10|10000 characters needed characters exceeded

  • Jun 13, 2017 at 04:39 PM

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

    Add comment
    10|10000 characters needed characters exceeded