Custom data extension and sharepoint integration mode
Hi all , i have create a custom data source with VS2005 that's work fine with VS 2008 report server project but when i have have add a report to the report library in sharepoint - that was integrated with SSRS 2008 - the report throw this error An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection) Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. so any suggestions ...
December 14th, 2010 12:21pm

Hi amir_samir, The issue might be caused by the code in the custom data extension is not trusted to execute. In order to troubleshoot the issue, could you please try to set the following code group to FullTrust to check if the report works fine? </CodeGroup> <CodeGroup class="FirstMatchCodeGroup" version="1" PermissionSetName="FullTrust" Description="This code group grants MyComputer code Execution permission. "> <IMembershipCondition class="ZoneMembershipCondition" version="1" Zone="MyComputer" /> The code group is existing in rssrvpolicy.config in folder <Install Driver>:\Program Files\Microsoft SQL Server\MSRS10.<Instance Name>\Reporting Services\ReportServer by default. Please also make sure the custom assembly is frull trusted. For more information about Code Access Security in SQL Server Reporting Services(SSRS), please see: http://msdn.microsoft.com/en-us/library/ms154658.aspx If you have any more questions, please feel free to ask. Thanks, Jin Chen Jin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
December 16th, 2010 12:43am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics