September 26, 2011 at 5:39 am
Hi All,
I am using Visual Studio 2008 to create reports, I am able to deploy the reports, but when I try to view them it gives the following error message:
The current action cannot be completed. The user data source credentials do not meet the requirements to run this report or shared dataset. 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 checked the Reporting Configuration manager to see if all the credentials are correct but I am stuck on what else it could be. Would someone be able to let me know what I am doing wrong please.
Thank you
September 26, 2011 at 7:36 am
Usually when I run into a problem like this I copy the dataset query into SSMS and run it with Execute As the user that the Report manager uses. SSMS will give you better feedback as to where the security issue is than the Report manager.
November 17, 2011 at 1:14 pm
Prior to deploying report, can you run the report successfully in Visual Studio.
If you can then the issue lies with the datasource in Report Manager (where you are deploying the report to).
If you can't run the report before deploying it then check the datasource credentials and configuration in the report itself in Visual Studio.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply