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: [cid:[email protected]] 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-37585fd7171f/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.
<<inline: image001.png>>
