Skip to Content

Fail to connect to tenant DB from Hana Studio

Hi Hana Experts,

I was able to connect to my tenant DB after setting the correct port(30013) via ODBC Administration, but in Hana Studio, there isn't a place to set the port.

I've watched this video on youtube, but he did not have any problem, and did not even need to specify 30013 to connect to a tenant.

https://www.youtube.com/watch?v=O47Fw7AXL3k

In my case, I'm unable to connect, and get an error saying the logon data cannot be used.

Also, I have two tenant DBs created by the following SQL queries.

CREATE DATABASE FC1 SYSTEM USER PASSWORD Admin123;
CREATE DATABASE FC2 AT LOCATION 'LSLES11SP3x64:30055' SYSTEM USER PASSWORD Admin123;

I've confirmed both tenants are reachable via ODBC(FC1 at port 30013, and FC2 at port 30056). Suppose I intend to connect to FC2 in Hana Studio, does it automatically know FC2 is at 30056?

Thanks in advance.

Best Regards,

Timtouna

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Nov 25, 2016 at 01:06 AM

    Seems to be a bug in Hana Studio 2.1

    Upgraded to 2.3, issue resolved.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Lars,

      So ODBC works as well?

      Is your DB single tenant or multi-tenant?

      Is your Hana Client version in line with Hana Server?

      I'm not a Hana expert, so purely guessing from my previous mistakes :)

      Best regards,

      Timtouna

  • avatar image
    Former Member
    Sep 04, 2017 at 11:03 PM

    I had the same problem.

    The solution was:

    Run the following command from the SYSTEMDB to know the sql port of my tenant:

    SELECT DATABASE_NAME, SERVICE_NAME, PORT, SQL_PORT, (PORT + 2) HTTP_PORT FROM SYS_DATABASES.M_SERVICES WHERE DATABASE_NAME = 'MDB' (or (SERVICE_NAME = 'indexserver' and COORDINATOR_TYPE = 'MASTER') or (SERVICE_NAME = 'xsengine'))

    From SAP HANA STUDIO

    Host Name: hostname:3XX15 (name or ip of my localhost:sql port of my tenant)

    Instance Number: XX

    Mode: Multiple containers

    Tenant database

    Name: MDB

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 28, 2016 at 02:58 AM

    also need to make a correction : 3xx13 is the port for systemDB, not for tenent DB

    the tenent DBs ports are allocated after 3xx40

    for example the SQL port of the first tenant DB at default location is 30041, second one is at 30044, third one 30047.

    connecting from Hana Studio 2.3, you don't need to worry about port, simply specify the DB name, it will connect for you, and then you can look up the port in the landscape tab.

    Add comment
    10|10000 characters needed characters exceeded