Nov 23, 2016 at 04:30 AM

Fail to connect to tenant DB from Hana Studio

8173 Views

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