Error: That assembly does not allow partially trusted callers. for Aspose.Cells for RS

When trying to export from Reporting Services, the export window opens and returns the error:

That assembly does not allow partially trusted callers.

I have installed Aspose.Cells for Reporting Services on my server:

  • Windows Server 2008
  • SQL Server 2008
  • Aspose.Cells v1.50

We are using other Aspose products and intend to purchase Aspose.Cells for RS as quickly as we can get the paperwork processed.

Is there something else that needs to be done to get this to work?

Rob

Hi,

We will check your issue and get back to you soon.

Thank you.

Any update? We are hoping Asprose can solve a few of our Reporting Services/Excel issues.

Rob

Hi Rob,

Please check the installation log and the SQL Server Reporting Services Policy file (rssrvpolicy.config) and post it here. If there is not a full trust caller for Aspose.Cells for Reporting Services in rssrvpolicy.config file, please manually add the permissions to execute.

  1. Give Aspose.Cells for Reporting Services permissions to execute. To do this, open ${SQL Server Reporting Services}\ReportServer\rssrvpolicy.config and add the following as the last item in the second to outer <CodeGroup> element (which should be <CodeGroup class="FirstMatchCodeGroup" version="1" PermissionSetName="Execution" Description="This code group grants MyComputer code Execution permission. ">):
  <!--Start here. -->
  <CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="FullTrust" Name="Aspose.Cells_for_Reporting_Services" Description="This code group grants full trust to the Aspose.Cells for Reporting Services assembly. ">
    <IMembershipCondition class="StrongNameMembershipCondition" version="1" PublicKeyBlob="00240000048000009400000006020000002400005253413100040000010001002780c08eaa89aedfb00b1b96137cca3e15f32826e0e4fd1da3c98d1e3968a03a019aa7b7228b151f6e5dae4dcb00f98479770f507626b04e786e5e93ec3757c1cc4ed1ac4b72c7649c4438e9d3a5f44d8b7522043686a2e8c2a495e04b917e0505d3201015c828e3c15afc8a46ab78293574b9e0475df68627bbabc5b564addd" />
  </CodeGroup>
  <!--End here. -->

Please refer to installation document for using DLL only.

Thank you.

Amjad Sahi:
Hi Rob,

Please check installation log and SQL Server Reporting Services Policy file (rssrvpolicy.config) and post it here. If there is not full trust caller for Aspose.Cells for Reporting Services in rssrvpolicy.config file, please manually add permissions to execute.

....

Amjad,

I made the changes to the rssrvpolicy.config file but am still receiving the error. I did stop and restart Reporting Services prior to testing.

In your post, you refered me to "installation document for DLL only." Do I need to follow these instructions as well? I installed Aspose.Cells using the .msi file.

I am attached the .config file, the install log and the error returned when trying to export.

Thank you for your quick response.

Rob

Hi,

Thanks for providing us the installation log, .config and error description files.

We will look into your issue and get back to you soon.

Thank you.

Hi,

We have checked your attachments and found that Aspose.Cells for Reporting Services installation failed.

Aspose.Cells for Reporting Services cannot get the CodeGroup tag of the PolicyLevel tag in rssrvpolicy.config.

The CodeGroup tag in your rssrvpolicy.config is not matched.

Please correct/fix your rssrvpolicy.config file and re-install Aspose.Cells for Reporting Services.

Kindly let us know if you still find any issue.

Thank you.

Amjad Sahi:
Hi,

We have checked your attachments and found that the installation for Aspose.Cells for Reporting Services failed.

Aspose.Cells for Reporting Services cannot get CodeGroup tag under PolicyLevel tag in rssrvpolicy.config.

The CodeGroup tag in your rssrvpolicy.config is not matched.

Please correct/fix your rssrvpolicy.config file and reinstall Aspose.Cells for Reporting Services.

Kindly let us know if you still face any issue.

Thank you.

I removed the unmatched CodeGroup tag and then reinstalled. Everything is working well now.

Thank you for your assistance.

Rob