Fixing external access to SAP HANA Instance on CloudShare

[matthias_fiebig]

Hello,

connect a SAP HANA Studio from my own desktop to the SAP HANA instance on Cloud Share, like descriped in the HOWTO

Part 4 - Connect to your local SAP HANA Studio and Sap HANA Client to your HANA server on CloudShare (optional).

doesn't work. After a service request on Cloud Share I got the information, that only the ports 22, 443, 80, 3389, 8080 are open for public access.

So that is possible: Add a local port forwarding on the SAP HANA Linux machine

iptables -t nat -A PREROUTING -i eth0 -p tcp --dport 8080 -j REDIRECT --to-port 30015

now you can change the destionation port in the system config of the SAP HANA Studio from 30015 to 8080 and it should work.

After the test you can save the config with.

iptables-save

I hope this helps.

Matthias

[raphael_branger]

Hi everybody

I guess everything is even much easier - if you once figured it out. Have a look at my latest blog post here: http://wp.me/p2nNXm-2Y

The key is that you configure a vanity URL for the HANA server in your Cloudshare account. Afterwards the server has its own public URL / hostname on <yourname>.vm.cld.sr

On this hostname even port 30015 seems to be open. At least I could connect from a different Cloudshare environment with BO 4.0 installed.

Best regards

Raphael

[matthias_fiebig]

Hello,

are you shure it works from outside cloudshare. At my tests the port was not open from the outside.

Matthias

[Former Member]

It worked perfectly fine for me as I just installed HANA Studio on my laptop. I am susbcribed to 30-days Free trial on Cloudshare. I simply changed 'External address' for HANA SPS5 server under 'Vanity URLs' and added that as 'Server' in HANA Studio on my laptop. I did not have to open any ports and it just simply worked fine.

[Former Member]

After I changed the 'Vanity URL' under my account, I couldn't access the HANA DB anymore, given an error from the HANA Studio ' the installed HANA database license is expired'. I rebooted the server, but it's still the same. Any clue? Thanks.

[Former Member]

Hello Animesh,

Today I have registered for 30 day trial HANA dev edition on Cloudshare. Me too changed External address' for HANA SPS5 server under 'Vanity URLs'. I am unable to connect to SAP HANA DB to HANA studio after that. Even I am unable to create a new system as its saying username and password are incorrect. I have provided the same password mentioned in blog.

Kindly help

Avijit