Custom data extension has trust issues

22 Jun 2006 12:41 PM

hokietoner

I wrote a custom data processing extension which works in preview mode,
but when viewing it from the report server I get the error:
----
An error has occurred during report processing. (rsProcessingAborted)
Cannot create command for data source 'MeridiumDataSource'.
(rsErrorCreatingCommand)
That assembly does not allow partially trusted callers.
----

I have put the correct codeblock tags in rssrvpolicy.config, right
after the codeblock with Url="$CodeGen$/*" as I'm supposed to:
----
<CodeGroup
       class="UnionCodeGroup"
       version="1"
       PermissionSetName="FullTrust"
       Name="MeridiumCodeGroup"
       Description="Code group for my data processing extension">
    <IMembershipCondition
       class="UrlMembershipCondition"
       version="1"
       Url="C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
Services\ReportServer\bin\MeridiumDataExtension.dll"
     />
</CodeGroup>
----

I have some 3rd party assemblies that my DPE references; I also put a
codeblock for them in rssrvpolicy.config:
----
<CodeGroup
       class="UnionCodeGroup"
       version="3.2.0.148"
       PermissionSetName="FullTrust"
       Name="MeridiumCoreCodeGroup"
       Description="This code group grants Meridium core code full
trust. ">
   <IMembershipCondition
       class="StrongNameMembershipCondition"
       version="1"
       PublicKeyBlob="[public key]"
    />
</CodeGroup>
----

I also put the followinig line in my AssemblyInfo.cs file:
----
[assembly: AllowPartiallyTrustedCallers]
----

None of these things changed the error. Any help would be greatly
appreciated.

22 Jun 2006 12:51 PM

Ryan

I guess I forgot to mention that this data extension is for reporting
services, and that this is sql server 2005.

22 Jun 2006 3:39 PM

Arnie Rowland

You might consider posting in the sqlserver.reportingsvcs newgroup.

--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."

*Yet Another Certification Exam

<hokieto***@gmail.com> wrote in message

Show quote

news:1150980095.588318.45210@p79g2000cwp.googlegroups.com...
>I wrote a custom data processing extension which works in preview mode,
> but when viewing it from the report server I get the error:
> ----
> An error has occurred during report processing. (rsProcessingAborted)
> Cannot create command for data source 'MeridiumDataSource'.
> (rsErrorCreatingCommand)
> That assembly does not allow partially trusted callers.
> ----
>
> I have put the correct codeblock tags in rssrvpolicy.config, right
> after the codeblock with Url="$CodeGen$/*" as I'm supposed to:
> ----
> <CodeGroup
>       class="UnionCodeGroup"
>       version="1"
>       PermissionSetName="FullTrust"
>       Name="MeridiumCodeGroup"
>       Description="Code group for my data processing extension">
>    <IMembershipCondition
>       class="UrlMembershipCondition"
>       version="1"
>       Url="C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
> Services\ReportServer\bin\MeridiumDataExtension.dll"
>     />
> </CodeGroup>
> ----
>
> I have some 3rd party assemblies that my DPE references; I also put a
> codeblock for them in rssrvpolicy.config:
> ----
> <CodeGroup
>       class="UnionCodeGroup"
>       version="3.2.0.148"
>       PermissionSetName="FullTrust"
>       Name="MeridiumCoreCodeGroup"
>       Description="This code group grants Meridium core code full
> trust. ">
>   <IMembershipCondition
>       class="StrongNameMembershipCondition"
>       version="1"
>       PublicKeyBlob="[public key]"
>    />
> </CodeGroup>
> ----
>
> I also put the followinig line in my AssemblyInfo.cs file:
> ----
> [assembly: AllowPartiallyTrustedCallers]
> ----
>
> None of these things changed the error. Any help would be greatly
> appreciated.
>