Источник:
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