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