Skip to Content
avatar image
Former Member

CAL SAP HANA Express, unable to connect with SAP HANA Studio

Hi all,

I request a server with SAP CAL for an instance with SAP HANA express studio.

I can access to HANA with SAP HANA web IDE for SAP HANA and SAP HANA Database Explorer. However, I cannot connect myself to HANA with SAP HANA Studio on Eclipse. I got the following message:

The system could not be reached. The logon data could not be used 

For the setting of the connection I follow this guide.

I don't think is an password problem since I have another error when the password is wrong:

Invalid user name or password

I think, it is a network problem but on the CAL dashboard, the security group allow the port that I used 39015. (I didn't change default security groupes).

Do you have any idea on why I cannot access to HANA with SAP HANA Studio?!? Do you need more information?!?

Thanks,

Romain

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 26, 2017 at 09:00 PM

    So, if you are accessing Web IDE I'm assuming your hosts file is mapped properly and you can reach your system. I just created a new machine, did not change the ports that are configured by default and used the following to access from HANA Studio, and it worked:

    Of course this applies to the system database. You can activate the JDBC trace for this connection by creating it anyways, right-clicking on it, properties and then JDBC trace, "Enable trace":

    That may give a better hint of what is going on.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Lucia Subatin

      It seems that I have no problem to reach the combination of host and port.

      I tried this:

      ➜  ~ telnet vhcalhxedb 39013
      Trying 34.234.98.64...
      Connected to vhcalhxedb.
      Escape character is '^]'.
      
      Connection closed by foreign host.
      ➜  ~ telnet vhcalhxedb 39015
      Trying 34.234.98.64...
      Connected to vhcalhxedb.
      Escape character is '^]'.
      
      Connection closed by foreign host.

      There is another host/port that I should test?

      Add to this, I have access to another Hana DB and I am able to reach it with SAP Hana Studio. The difference is that I use 'tenant db' configuration instead of 'system database'.