SAP HANA Direct Connection - Error [10] authentication failed

Identity Security Cloud (ISC) ISC Discussion and Questions
, , ,
1

Hi Team,

We are performing a test connection with the SAP HANA OOTB connector in ISC. When we try to connect, we get a “[10] authentication failed” response. The same response can be obtained with the JDBC connector.

image

We have already checked the service account permissions and tried to create a new account and password. We have also tested the URL and port in the VA via telnet and the connection is correct.

The logs in the VA show the same authentication error even at the debug level.

Do you have any suggestions?

Regards.

2

Hi @ArielM

Welcome to the developer community!

Are you able to connect to the DB with the same credentials using a DB client outside of ISC?

Check the username syntax too, might be expecting the username to be passed in a certain format.

Hope that helps

3

Hi @ArielM,

Assuming you are using SAP Direct connector, If possible try to capture the logs from SAP HANA by turning the trace log on the service account and try to test the connection from SailPoint and see if you can find any authorization issues that are captured in SAP trace log.

Based on the trace log, assign missing auth objects to service account, if there are any. That might help us debug deeper.

Thanks,
Vijay

4

Hi everyone,

We couldn’t see any more information with the trace level of the logs in VA other than the authentication error.

It turned out that the problem was that the service account was created in the tenant DB in HANA, but not in the system DB. Now with the account in both DBs we can successfully connect, but HANA sometimes automatically locks the service account when trying to test the connection to the database or perform an aggregation task.

We are currently working with the customer to see what could be the issue.

Thanks for the answers.

5

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.