Skip to Content
0
Dec 13, 2021 at 04:45 PM

WebIDE sap hana service connection: authentication failed for LDAP provisioned DB user

492 Views

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).