HANA DB Studio not connecting to Multitenant

[troy_sorbet]

I am trying to get HANA db studio version 2.3.35 to connect to my HANA 2.3 instance. As listed the connection attempts get an odbc error. My hana instance is a vmware Linuz RHEL 7.4 installation. The client and DB studio are install on a windows 2012 server and a windows 7 machine. The issue is the one listed a couple of times regarding the studio trying to connect to port 30515 and needing to connect to 30541. I read sap note 2101244 which identifies the issue but doesn't state how to get around the port issue. I cannot find a global.ini file to edit on either of my installations so what am I missing here.

Thanks In advance

Troy Sorbet

output

com.sap.ndb.studio.jdbc.JDBCConnectionStatus: Database connection is not available; see error log at com.sap.ndb.studio.jdbc.JDBCPlugin.createConnection(JDBCPlugin.java:281) at com.sap.ndb.studio.navigator.operations.SAPSystemObjectUpdate.executeTryJDBC(SAPSystemObjectUpdate.java:283) at com.sap.ndb.studio.navigator.operations.SAPSystemObjectUpdate.execute(SAPSystemObjectUpdate.java:103) at com.sap.ndb.studio.navigator.operations.UpdateSAPSystemOperation.execute(UpdateSAPSystemOperation.java:73) at com.sap.ndb.studio.datamodel.controler.DataModelOperation.execute(DataModelOperation.java:70) at com.sap.ndb.studio.datamodel.controler.DataModelOperationQueue$DataModelOperationThread.run(DataModelOperationQueue.java:99) Caused by: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Cannot connect to jdbc:sap://s########m [Cannot connect to host s########m:30513 [Connection timed out: connect (local port 52254 to address 0:0:0:0:0:0:0:0, remote port 30513 to address 132.172.231.117 (s########m.s##.###.###))], -813.]. at com.sap.db.jdbc.exceptions.SQLExceptionSapDB._newInstance(SQLExceptionSapDB.java:126) at com.sap.db.jdbc.exceptions.SQLExceptionSapDB._newInstance(SQLExceptionSapDB.java:203) at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.newInstance(SQLExceptionSapDB.java:50) at com.sap.db.jdbc.Driver._connect(Driver.java:1434) at com.sap.db.jdbc.Driver.connect(Driver.java:1068) at com.sap.ndb.studio.jdbc.JDBCConnection$1.run(JDBCConnection.java:169)

[pfefferf]

What is the instance number of your machine? 05 or something else?

[troy_sorbet]

The instance number is 05 sid is HDB

[ayman_salem]

as I see from the log:

com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Cannot 
connect to jdbc:sap://s########m [Cannot connect to host 
s########m:30513 [Connection timed out: connect (local port 52254 to 
address 0:0:0:0:0:0:0:0, remote port 30513 to address 132.172.231.117 
(s########m.s##.###.###))], -813.]. at

it can not connect to your HANA SystemDB (Port 30513),

First check that the HANA system has the address "132.172.231.117".

Second, check the firewall on HANA system and on the client (open the ports you want)

[lsubatin]

Have you tried forcing the tenant and port as in step 7.b here (sounds like HDB:30541 in your case)? https://www.sap.com/developer/tutorials/hxe-howto-eclipse.html