sql server - SSRS 2008 User Generated Report Subscriptions with Windows Integrated security - possible? -

There is a problem with my SSRS 2008 configuration at this moment. We are currently setting up this way.

There is no integration with 1 server SQL Server and SSRs hosting, SharePoint etc. Users use the SSRS web application, and since then they also reach "Report Builder 1.0", which they can use to create and run reports based on a reporting model.

All of this is fully used in Windows authentication - so they log into the web application from their domain account, and then when loading the Report Builder. Rather than using a normal SSRs account, each domain user is configured to be able to login to SQL Server, and all the above mentioned tasks have been corrected.

The way this setup is, this means that you can always tell which personal user is logged in and the report is running - on the website or by running a report through Report Builder. This application is a requirement because all users will see a slightly different version of the data model (it is controlled by the underlying ideas, depending on the domain account that runs the query account). Tom can get 100 rows from his query, but Harry will get only 50, etc.

Datasource is setup to use integrated security (which passes through SQL Server through this domain account).

My problem comes when a user creates a report in the Report Builder, and then saves it on the server when they login into the web application and run the report there - it works fine , But when they try to set up an email subscription, they receive this message:

"Subscriptions can not be made because the reports used to run the credentials are stored Or if any linked report, link is no longer valid "

Due to some research, I think it is under integrated security settings, for some reason SSRs currently logged on users Ignore the account or can not be used to set up that membership

If I set up a data source to use a specific account - but then whatever user account The filter data on the basis (of course, because it will have to use one account for all!)

P>

I can do this? Is there a configuration setting that I am trying to use integrated security and can work it out? Any help / comments are appreciated!

You must get some rex to create a report subscription:

is the first ,

  A report that can run unused (which is a report that does not use stored credentials or any credentials)  

what you do I suggest you subscribe setup data powered by me. There is a link to get you started There are several good videos of basic setup like SqlLunch # 8

Here's another more popular way:

Hopefully Anyone can help you with this.

It's OK to have a good one in your device belt.