emeadaxsupport: Microsoft Dynamics AX 2012 Reporting extensions: Error System.Security.Permissions.SecurityPermission while running report

[Blog bot]

Источник: http://blogs.msdn.com/b/axsupport/ar...ng-report.aspx
==============

Sometimes we can see that when running some Reporting Services report (ie: TS_DeliveryPerformanceWebPart.Report we get error

System.Security.Permissions.SecurityPermission
Aditionaly in Microsoft SQL Reporting Services log you can see following error

ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'ConfirmDateParameterValues'. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Security.SecurityException: System.Security.Permissions.SecurityPermission at
TS_DeliveryPerformanceWebpart.ConfirmDateDataTable()
The type of the first permission that failed was: System.Security.Permissions.SecurityPermission
The Zone of the assembly that failed was:
MyComputer
The issue happens because of not correct entry in file rssrvpolicy.config. To fix the problem.

1. Open rssrvpolicy.config

• If you are using SQL Server 2008, the default location of this file is: \Program Files\Microsoft SQL Server\MSRS10.[SSRSInstanceName]\Reporting Services\ReportServer.
• If you are using SQL Server 2008 R2, the default location of this file is: \Program Files\Microsoft SQL Server\MSRS10_50.[SSRSInstanceName]\Reporting Services\ReportServer.

2. Double check that entries like (all business logic libraries):








are located under entry


The problem can occur when you used msdn article: http://technet.microsoft.com/en-us/l.../hh389762.aspx as the step 7 in section "Modify the report server RsSrvPolicy.config" we should add the mentioned tag in section:




We are working on changing this article.

You can also open the configuration file from default environment and compare it with the one from changed environment.



--author:Jolanta Malkowska, Czesława Langowska Vliegen--ediror:Czesława Langowska Vliegen


Источник: http://blogs.msdn.com/b/axsupport/ar...ng-report.aspx