How do you use passthrough authentication for MS SQL Server 2008?

[MichaelAndry]

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

[Former Member]

Hi,

Refer the below note.

1387622 - How to use secondary credentials for database connections and how to auto populate the sec...

[MichaelAndry]

Thanks Ajay, but this doesn't work.

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

What you indicate is step #2.  BO is passing the credentials from our users just fine.  The problem is that BO is trying to login to MS SQL Server 2008 with SQL Server Authentication using the users' credentials.  Our users don't have SQL Server accounts, they have Windows AD accounts.

[CdnConnection]

Michael,

     Once you have integrated the BI Plaform with SSO using AD Authentication, all you have do is changes the UserID and password for the database connection.

• For user id type "@BOUSER"
• For password type "@BOPASS"

This will pass the AD Auth SSO ID and password to the SQL Server.

Regards,

Ajay