Hi All,
I have built an MTA, created a HDB and a SAP HANA service connection.
When building a calculation view, and browsing for the object, I am getting "Error: Incorrect Service: Connect error: authentication failed".
I created a user provided service name and verified that the connection details are correct by using the same credentials via command line (hdbsql).
I cannot figure out what is causing this authentication issue. The user which I am using is a domain user created in Active Directory and provisioned automatically in SAP HANA DB via LDAP Provider.
But the user exists in the tenant db now and I can log into the database. Why is this not working via WebIDE??
So as a quick test, I created a new SAP HANA service connection this time using a regular db user (i.e. SYSTEM), and I am able to build the calculation view. So I know that the issue is with my LDAP assigned db user. The puzzling thing is that I can connect to the HANA DB directly and also through the Database Explorer in WebIDE (using the LDAP user).