Windows AD authentication impacting HANA database credentials

[Former Member]

Hello,

I've recently setup Windows AD authentication in BI 4.1 SP5, and users are reporting that after they login using AD authentication, their database connection does not work.

Here's a breakdown of the steps they follow and how they get the connection to work by switching to Enterprise authentication. Has anyone experienced this before? Is there an SAP note that addresses this issue?

1. Log on to BOE with AD (all lower case)

2. Open report (HANA Connection is not working):

3. Log in with Enterprise

4. Open Report (HANA connection not working)

5. Check CMC (Database credentials look good)

6. Enter password again for HANA Credentials

7. Log in to BOE Again with Enterprise

8. Open Report (HANA Credentials are working)

9. Log in to BOE Again with AD (all Lower Case)

10. Open Report (HANA Credentials are not working)

[Former Member · Accepted solution]

This was resolved by unchecking the 'synchronization of credentials'.

[Former Member]

Do you have the WINDOWS AD User and Enterprise user clubbed with aliases?

Dont you have WINDOWS AD SSO setup? If yes then what happens when you login using WIN AD SSO?

What happens when you try to test the connection to HANA DB, from IDT?

[Former Member]

If this is crystal report, then please import and open the report in the crystal report designer. Enter the database credentials here, save it and export it back to repository.

Test the issue after doing this

[Former Member]

Hi Srikar,

This is a web intelligence report not crystal.