Cannot connect to SAP hana Express DB using eclipse studio

[former_member606213]

I am new to SAP HANA database . i have sucessfully hosted the SAP HANA express database on cloud server . i have created database and i am able to querry them for CLI. However i have trouble connecting it from eclipse have spent two days on the same I am following https://developers.sap.com/india/tutorials/hxe-howto-eclipse.html tutorial.

Please Note : 1) I am able to connect to server using RDP and putty so the IP address is correct 2) I have started the database using command hdbsql -i 90 -d HXE -u SYSTEM -p SAPhxe123 3) why is eclipse taking port 39015 by default in last screenshot? is this the issue or can we change this.

Any help here would be much appreciated!!!

[nageshcaparthy]

andreas.schuster2 any suggestion on this question????

Regards,

Nagesh

[pfefferf]

Why are you adding a port number in the tenant database field? This is wrong, only the database name needs to be entered (e.g. HXE).

[former_member606213]

florian.pfeffer tried adding only HXE without port number in tenant database field , but still the same issue , also how can i change the default port from 39015 to 39017?

i am struggling on this since a week now , any help would be appreciated.

[pfefferf]

You do not have to change any port settings.

I guess you missed the steps to configure the public hostname resolution, like described here.

[former_member606213]

Thanks for responding

But that is once i am able to connect the DB and get it on list , currently the administration button is disabled

Also the reason i am asking this is the eclipse is taking port 39015 , however the SAP hana Express docker command uses port 39017 .

[pfefferf]

The settings have to be done in the system db. Are you not able to connect to the system db too? And please explain how you set up your express instance. In your question you wrote in the Cloud. What means that, GCP, Azure, any hosted linux system on which you run express in docker ...???

[ydharmakar75]

Hi,

You can select the System Database instead of Tenant database in specify system window (First Screenshot).