When trying to run FreeTextInvoice.Report from Dynamics AX 2012 using SSRS 2008 r2 keep getting the following error whilst trying to print:-
Error while setting server report parameters. Error message: The permissions granted to user 'TestUser' are insufficient for performing this operation. (rsAccessDenied)
Stack trace: Call to TTSCOMMIT without first calling TTSBEGIN.
(S)\Classes\CustPrintOutInvoice\printOut - line 123
Also looking at SQL Server 2008
r2 SSRS Log files at:-
C:\Program Files\Microsoft SQL Server\ServerName\Reporting Services\LogFiles
ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: , Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'TestUser' are insufficient for performing this operation.;
Fix was quite easy but not obvious to find:-
Bascially check all folder permissions and that they are inheriting from the root.
e.g. this particular report FreeTextInvoice.Report is contained within the DynamicsAX/StaticReports/en-GB (and other languages). But for some reason this folder didn't inherit the permissions from the root (DynamicsAX).
So all I do is navigate to the folder and then click the "Revert to Parent Security".