SSRS using SSIS as a Datasource
I need assistance with which accounts need to be modified to be able to run SSRS using a SSIS datasource.
April 8th, 2011 2:17pm

Hi, Which version of Reporting Services you are using? In Reporting Services 2005 and 2008, we are able to configuring Reporting Services to use SSIS package data. For detailed steps, please refer to http://msdn.microsoft.com/en-us/library/ms345250.aspx However, this feature has been deprecated and removed in SQL Server 2008 R2 due to security reasons. For possible workaroud, please refer to http://blogs.msdn.com/b/jenss/archive/2010/07/11/ssis-as-a-data-source-for-ssrs-where-is-it-gone-for-sql-server-2008-r2.aspx Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
April 12th, 2011 11:57am

I'm using SQL Server 2008R2....
April 12th, 2011 1:14pm

Thank you...
Free Windows Admin Tool Kit Click here and download it now
April 12th, 2011 1:16pm

I have ran the ssis log and found that the nt Authority/System and the domain account are being used to run the ssis package.
April 12th, 2011 1:23pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics