Check your permission on the view called vCI_ComplianceSummary, I bet is it not the same and other SQL views.
Keep in mind that the Query will run based on the permission set by the Data source. From: [email protected] [mailto:[email protected]] On Behalf Of Dzikowski, Michael Sent: Tuesday, October 1, 2013 5:16 PM To: [email protected] Subject: [mssms] OT: SSRS question, adding dataset breaks report So, I'm adding a simple query / dataset to an SSRS report. But when I run the report I am getting an error: Query added in the DataSet- returns results: The error I get is: The SELECT permission was denied on the object 'vCI_ComplianceSummary', database 'CM_CAS', schema 'dbo'. ---------------------------- Query execution failed for dataset 'DataSet5'. (rsErrorExecutingCommand) ---------------------------- An error has occurred during report processing. (rsProcessingAborted) Googling around says I need to give execute permissions to fnLShortNameToLCID, it looks like that is already set when I check. http://social.technet.microsoft.com/Forums/en-US/859d33a2-b1eb-4975-89e8-375 85fd7171f/report-application-deployments-per-asset-fails 1. I verified the account used to run the reports has DBO permissions on the SCCM database. 2. All other queries work in other DataSets in the report Any other thoughts? The query works in SQL Management Studio and in the Query Designer in SSRS.
<<image001.png>>
