SSRS 2012 -we have aset of report all using the same data source: XXXXX
They were developed years ago, but I think when theymigrated from 2008 to 2012 something changed. There are a set of “click through” reports and the report ID clickedthrough to depends on the special failure severity and RFP.(Contract rule). Sowhen the team tested these they may not have ran across the few in the set thatuse embedded SQL Text. Each of these reportsfail
Why? They use the samedata source. It is definitely thesesmall subset that have trouble, none of the rest.
An error has occurredduring report processing. (rsProcessingAborted)
Query execution failedfor dataset 'ServiceName'. (rsErrorExecutingCommand)
The SELECT permissionwas denied on the object 'ServiceRequired', database 'XXXXX', schema 'dbo'.