Our goal is to allow users to schedule Web Intelligence documents against MS SQL Server 2008 using Windows Authentication.
Users are granted access to the MS SQL Server 2008 through Windows AD Authentication, - NOT SQL SERVER ACCOUNTS.
This configuration works for SSO - users can log into InfoView and refresh Web Intelligence documents. We cannot get it to work for passthrough to allow scheduling.
Authentication mode: Use BusinessObjects credential mapping
Scheduled report error: "DBD: [Microsoft SQL Server Native Client 10.0]: Login failed for user 'user1'.
Is it possible to configure passthrough authentication to MS SQL Server 2008?
Steps for Reconstruction
1. Grant access for users to MS SQL Server 2008 via AD domain accounts.
2. Create a universe connection with authentication mode set to "Use BusinessObjects credential mapping".
3. Run a report, test universe connection, schedule a report and you get this error:"DBD: [Microsoft SQL Server Native Client 10.0]: Login failed for user 'user1'.
Business Objects Enteprise XI 3.1 SP6 FP6.1