SSRS 2008 R2 running in SharePoint 2010 Integration mode - Not able to schedule reports.
Hi, I am unable to schedule report am getting following error when trying to schedule an SSRS report from ReportViewer Webpart in SharePoint 2010. The current action cannot be completed. The user data source credentials do not meet the requirements to run this report. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified. (rsInvalidDataSourceCredentialSetting) I have SSRS 2008 R2 running in SharePoint 2010 Integration mode on Win 2008 R2 System. I have also setup the unattended execution account from the Reporting Services Configuration Manager, which has appropriate privilates on the database to generate report. Also, I have reporting webservice setup @ following url (am using the named instance of SQL Server): http://<Servername>/ReportServer_SQLSERVER97170 Am able to view the report from report viewer webpart but unable to schedule it. Kindly let me know what's going wrong. Thanks in Advance, Sachin R. Chavan.Sachin R. Chavan.
May 21st, 2011 10:18am

Have you checked the optione "Impersonate the authenticated user after a connection has been made to the data source"? If so, can you uncheck it and try?
Free Windows Admin Tool Kit Click here and download it now
May 21st, 2011 10:55am

Could you please let me know where do i check this option?Sachin R. Chavan.
May 23rd, 2011 12:43pm

In the Data Source properties.
Free Windows Admin Tool Kit Click here and download it now
May 23rd, 2011 1:38pm

It will be great if you can let me know where which Data Source properties I need to look into. SQL Server? Report Server? SharePoint? How to reach upto that page?Sachin R. Chavan.
May 24th, 2011 9:32am

Hi Sachin, Generally, this error is caused that impersonation is used in a scheduled operation. In Native mode, we need to uncheck the option “Impersonate the authenticated user after a connection has been made to the data source” as Shahfaisal suggested, However, since your Reporting Services is integrated with SharePoint, please check and make sure the “Set execution context to this account” is disabled of the data source. For the detailed steps about How to Create and Manage Shared Data Sources (Reporting Services in SharePoint Integrated Mode), please refer to http://msdn.microsoft.com/en-us/library/bb283152.aspx Thanks, Tony Chain Tony Chain [MSFT CSG] | Microsoft Community Support 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
May 25th, 2011 11:32pm

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

Other recent topics Other recent topics