Skip to Content
avatar image
Former Member

HANA STUDIO 2.0 and Tenant DB (HANA SP09)connection problem

Hi,

I am trying to connect to my HANA instance created as Multi-tenant DB(Native) using the HANA Studio which I have upgraded to version 2.0.

I am able to successfully connect to SYSTEMDB.

But when I try to connect to the tenant DB (which is up an running)

using the HANA studio it fails to find this and didn't connect.

The tenant DB is running and perfectly OK as I can connect to it use hdbsql \c command from my PC as well (after specifying the port number 30041 along with the host number).

In HANA studio I don't find a place where I can specify the port number. I have tried by using -n hostname:port in the additional JDBC option text box but it doesn't help.

Any ideas?

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Dec 18, 2014 at 02:50 AM

    Hi Anurag,

    You don't need to specify the port number when adding SAP HANA system. Just input the host name, instance number -> Select "Multiple containers" -> Input the name of the tenant database container -> Next -> Input the username and password -> Finish.

    That's it.

    Best regards,

    Wenjun


    Capture.PNG (48.4 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Anurag,

      After Native installation you have to create the DB using below SQL command after that only you able to add the tenant DB in the hana studio.

      CREATE DATABASE <DBNAME> SYSTEM USER PASSWORD <PASSWORD>

      Please let me know if you have any issues.

      Thanks

      Raju

  • May 17, 2016 at 06:29 AM

    Hi,

    Can you provide the error that you get in studio on adding the tenant db.

    Regards,

    Anjali

    Add comment
    10|10000 characters needed characters exceeded

  • May 21, 2016 at 11:29 PM

    http://help.sap.com/saphelp_hanaplatform/helpdata/en/ff/e46fc6c592466d847047b7587476fb/content.htm

    The link above is for information on how to map network for database client when multiple networks or firewalls affect connection to Tenant database via Hana Studio.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 22, 2016 at 08:10 AM

    Hello

    you don't have to provide the port, just give the correct Tenant DB name with host and instance number.

    I am working on a machine with 3 Tenant DBs and all of them have different ports then 30015, in my case my tenant DB is running on port 30044


    tenantDB.png (33.6 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      thanks for the reply, but I have created a database in this case DB1, but neither that nor the original single instance database HDB which is now a tenant database can be added to HANA Studio as tenants. when you try to add them as systems in HANA Studio it just hangs, returns an error saying they can't be reached do you want to add anyway.

      The odd thing is that post the conversion HDB can been connected to from HANA Studio but not as a container/tenant but just as it was just before the conversion as it's listening on port 30015.

      Regards

      Simon C.