Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm looking into using Forms authenticaiton for SSRS. I got it working using Microsoft's sample found here: http://msftrsprodsamples.codeplex.com/wikipage?title=SS2008!Security%20Extension%20Sample

However, I'm wondering what authentication to use to the SQL Server data source. When I use Windows Authentication I get this error:

An error has occurred during report processing. (rsProcessingAborted) The execution failed for the shared data set 'ActualYears'. (rsDataSetExecutionError) Cannot impersonate user for data source ' Data source for shared dataset'. (rsErrorImpersonatingUser) This data source is configured to use Windows integrated security. Windows integrated security is either disabled for this report server or your report server is using Trusted Account mode. (rsWindowsIntegratedSecurityDisabled)

When I use SQL Server Authentication it prompts me for the credentials when I run a report, even though my data source has the user and password specified in the connection string. So when I run the built-in Report Manager I have to log in for forms authentication. Then when I run a report I have to log in again for SQL authentication.

If using Forms authentication do you have to use SQL Server Authentication or can Windows Authentication somehow work? Also, is there a way to get SQL Server Authentication to not prompt you for the credentials, but to use those already supplied in the connection string?

share|improve this question

migrated from serverfault.com Jan 14 '13 at 17:35

This question came from our site for professional system and network administrators.

    
This question is borderline for me, it may be better answered on Stack Overflow. We'll see what the rest of the community thinks. –  Brent Pabst Jan 14 '13 at 15:05
    
One possible suggestion however would be to check to see what service accounts the SSRS web interface is using and ensure that the Forms Auth tool does in fact load an impersonated user. –  Brent Pabst Jan 14 '13 at 15:06
add comment

1 Answer 1

I somehow missed seeing the Credentials section you can set for a data source. This way I can use SQL Server authentication and it works.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.