Connection to tenant database fails for S/4HANA 2021 FPS01

[andreas_froehlich1]

I have a new appliance SAP S/4HANA 2021 FPS01 in SAP CAL. On my local Windows PC the connection from SAP Hana Studio to a tenant databasefails with this error:

com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Cannot connect to jdbc:sap://vhcals4hci [Cannot connect to host /10.0.0.228:30241; socket timeout [null], -813.].

Connecting to the system database works and inside of the Windows Remote Desktop machine both kind of connections also work fine (after downgrading from JDK11 to JDK8, but that's another story....)

I've edited my local Windows host files according to the one on RDP:
12.34.56.78 vhcalhdbdb.dummy.nodomain vhcalhdbdb vhcals4hcs.dummy.nodomain vhcals4hcs vhcals4hci.dummy.nodomain vhcals4hci # added by a service of the CAL Appliance Agent
with the 1st number the SAP S/4HANA 2021 FPS01 Externe IP-Adresse but I've omitted this line which I didn't understand:
10.0.0.229 frontend.dummy.nodomain frontend # added by a service of the CAL Appliance Agent

In Hana Studio I used these connecting credentials
host name: 12.34.56.78
Instance number: 02
Tenant database: S4H
User: SAPHANADB
Password <My master pw>

In SAP CAL I added for the appliance these port ranges: 30200-30212 and 30216-30252 as Service "HTTP".
There was e.g. already the port range 30213-30215 as service "HANA DB". I've also tried with various different host names but without any luck.

I hope that someone can give me a hint how to solve this. Thanks in advance and regards,
Andreas

[naeem_maqsud · Accepted solution]

Hi Andreas,

I'm not familiar with this CAL solution so what I say is general info about HANA studio connection from local laptop to tenant db with HANA in a public cloud.

If you are using external IP address then it ought to work especially when you say connection to SYSTEMDB is OK. So no firewall issues here. Normally you don't need to specify the port number in HANA Studio but sometimes you may need to.

So use the same connection details but for hostname use -- <external ip address>:<port number>

You can figure out the sql port number by connecting to systemdb first and use the below SQL command (if you don't already know it)

Select * from SYS_DATABASES.M_SERVICES

Use the SQL PORT as the port number for the tenant db.

If this still does not work, check HANA Studio version as I've fixed connection problem just by upgrading.

Hopefully this works.

Cheers,

Naeem

[andreas_froehlich1]

Adding the port number to the hostname solved my issue! I didn't notice the "SQL_PORT" column in this table before, it's 30241 in my case.

Thanks a lot for this hint!
Andreas

[andreas_froehlich1]

I've used the external IP address of the HANA virtual machine, "12.34.56.78" was just a way of not writing the real address to this ticket.

[JoergWolf]

Hi Andreas,

the IP address (12. ...) looks like the "internal IP" that is only valid within the hyperscaler segment (eg. if conecting from RDP to HANA).

From your local PC, try with the "external IP" address of the HANA virtual machine.

Best,

Joerg