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