Skip to Content
May 13, 2020 at 09:19 PM

BusinessObjects Credential Mapping with SQL Server Database

467 Views Last edit May 14, 2020 at 11:12 AM 2 rev

I have come across a few links related to this topic in the SAP Community forums however unable to find an answer. We are trying to use 'BusinessObjects Credential Mapping' in IDT's connection connecting to SQL Server database. We use LDAP for authentication to BOE (BI4.2 SP5 Patch600). The universe connection test is successful from the workstation but the report fails from BOE server because the user's network credentials are unable to bypass the service account SIA is running on. On the BOE server we have defined ODBC DSN for SQL Server database (Integrated Windows Authentication and not SQL Auth). I found this Kbase 1869952 to configure kerberos however the point #2 under 'Important things to note before engaging in this complex process' says this:

Kerberos SSO to the DB is not possible if you logged into BI with enterprise, LDAP, SAP, siteminder, trusted authentication, or anything other than AD/kerberos (KBA 1631734)

Has anyone successfully used BO credential mapping to SQL Server database with LDAP authentication? Is this supported or even doable?

Please note: We have the database credentials enabled for each of our users under CMC --> Users and 'Enable and update user's Data Source Credentials at logon time' under CMC - Authentication - LDAP

BO Credential mapping works for us with Oracle database when report is run from BOE server (BI Launchpad or CMC).

Appreciate any inputs.