Custom assembly, not a trusted assembly

Hot Topic

this should be easy but it's not.
Difference between Shrinking a DB and a FILE
problem in using xp_cmdshell to run dts package
SSIS Tutorial giving Me Grief
Dynamic loading of a file
Meta Data
How to access report parameters in custom code
Very Lost while trying to Configure “Web Service Identity”
CREATE TABLE/VIEW from stored procedure or SELECT...
Lookup Transform with Variable Parameter

SQL Server

Text in to Datetime Question
Here is one more failure that I can not get by . . .
SQL Server 2005 Remote Connection
Why does the index lock my updates in SQL Server 2005?
Reporting Server useing Web Services footer problem
how to access a cube and its dimensions in a cube
How do you export SQL 2005 Maintenance Plans?
Display quote in data using select statement
Event ID: 107 MSSQLSERVER cannot connect to the report server database
SSIS Bulk insert to 2k

Custom assembly, not a trusted assembly

When I add a reference to my custom assembly to the report and try to preview it I get the following error message:

---------------------------
Parameters Error
---------------------------
The report references the code module ‘Employee, Version=1.1.0.0, Culture=neutral, PublicKeyToken=null’, which is not a trusted assembly.
---------------------------
OK  
---------------------------

I have modifed the reporting services rspreviewpolicy.config and rssrvpolicy.config with the following:

                       <CodeGroup
                                    class="UnionCodeGroup"
                                    version="1"
                                    PermissionSetName="FullTrust"
                                    Name="Custom_Code_Group"
                                    Description="This code group grants custom code full trust. ">
                                <IMembershipCondition
                                        class="UrlMembershipCondition"
                                        version="1"
                                        Url="C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PublicAssemblies\Employee.dll"
                                />
                            </CodeGroup>


However it has made no difference. I know I must be missing something. Can anyone point me in the right direction.

Thank you in advance.


Answer this question

Custom assembly, not a trusted assembly

  • udotan

    I just upgraded from RS 2005 Beta 1 to Beta 2. Now I'm having the same problem. I had all of my custom assemblies working fine in Beta 1. When I installed Beta 2, I gleaned from a few postings that I had to move my assemblies to

    C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies

    Done.

    I then modified RSPreviewPolicy.config in the same folder to give access to these assemblies.

    <CodeGroup class="UnionCodeGroup"
       version="1"
       PermissionSetName="FullTrust"
       Name="SystemCommon"
       Description="Grants permissions to the User Utilities assembly">
       <    IMembershipCondition class="UrlMembershipCondition"
          version="1"
          Url="C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\et.User.SystemCommon.dll"
       />
    </    CodeGroup>

    Doesn't work.

    "The report references the code module 'et.User.SystemCommon' .... , which is not a trusted assembly."

    Question : are there any significant changes to Code Access Security from Beta 1 to Beta 2 In Beta 1, if you did anything wrong in the config file (ie "URLMembershipCondition" vs. "UrlMembershipCondition"), the whole IDE gave out. I'm wondering if perhaps this is a more subtle way of telling me the same thing

    Significantly, the reports are working fine on the server.

    I'ma go getta coffee.

  • jeff_akbm

    There was a problem with custom assemblies in some of the earlier builds.  Your solution should work for the released version.
  • Custom assembly, not a trusted assembly
Answer this question