Gateway Hana Connection Successful but Report with Direct Query Fails

[pcgeekus]

Gateway Hana Connection Successful but Report with Direct Query Fails.

The Gateway is run with a Domain Account with SPN set, the new Data Source Tested good and SSO box is checked, but when a Report is published using Direct Query and the exact same Hana server name, all we see are Xs instead of data.

Tried a 2nd Data Source with a different name and user credentials and got an error that it was a duplicate? What? Surely more than one user can have a connection to the same Hana Sidecar -- right?

[Anonymous]

Hi Lydia,

I'm facing a similar issue but I struggle to get the log file as you commented. You mention 'replace domain\user with your account'. Which account do you mean?

Would be great if you could help me troubleshoot my issue. Without SSO to HANA all works well, but with SSO enable I get invalid crentials.

Kind regards,

Martijn van Foeken | Interdobs

[joel_gibby_csc]

Hi Martijn,

This might be helpful as a start:

https://www.youtube.com/watch?v=6gDZBC-UV_w