all groups > sql server reporting services > december 2004 >
You're in the

sql server reporting services

group:

Sharepoint/RS Error


Sharepoint/RS Error CJ Taylor
12/7/2004 5:01:14 PM
sql server reporting services:
I'm going nuts...

Alright, so I'm trying to write a custom web part for viewing reports using
the sample that came with MSRS 2000 to be deployed in sharepoint. I know
BML has a set of controls that heavily uses javascript, I'm trying to do
this server side but running into a mess of issues.

First of all, I'm all SP'd as far as I know. At least thats what my admin
tells me. And I've added the following lines to my policy file of my
sharepoint policy config (WSS_Medium_custom.policy.config)

<CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="FullTrust">

<IMembershipCondition version="1" AssemblyVersion="1.0.0.0"
Name="ReportHostWebPart" class="StrongNameMembershipCondition"
PublicKey="49b56234388a356c" />

<IMembershipCondition version="1" AssemblyVersion="1.0.0.0"
Name="ReportViewer" class="StrongNameMembershipCondition"
PublicKey="49b56234388a356c" />


</CodeGroup>



Ok. So when I do this, I can either access Sharepoint, or I can access
Report Server. But not both... If I access Report server first (through the
manager) it works fine. but sharepoint doesn't.

if I access sharepoint first then I can't access report server, and I get
this error





Server Error in '/Reports' Application.
--------------------------------------------------------------------------------

Configuration Error
Description: An error occurred during the processing of a configuration file
required to service this request. Please review the specific error details
below and modify your configuration file appropriately.

Parser Error Message: Assembly system.web.services.dll security permission
grant set is incompatible between appdomains.

Source Error:

Line 251: <add assembly="System.Web, Version=1.0.5000.0,
Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
Line 252: <add assembly="System.Data, Version=1.0.5000.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
Line 253: <add assembly="System.Web.Services,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
Line 254: <add assembly="System.Xml, Version=1.0.5000.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
Line 255: <add assembly="System.Drawing, Version=1.0.5000.0,
Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>

Source File:
c:\windows\microsoft.net\framework\v1.1.4322\Config\machine.config Line:
253




--------------------------------------------------------------------------------

Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET
Version:1.1.4322.573





Losing my mind on this.. trying a few more things... but no idea if they
will work. Anyone else run into something similar?



Re: Sharepoint/RS Error CJ Taylor
12/8/2004 9:50:52 AM
Looks like I solved the problem.

Alright, there is a significant difference between publicKeyToken and
publickeyblob I realized. You have to use the secutil to extract your
publickeyblob and put it into your policy file in sharepoint (giving it full
trust permission set). That took care of my problems and let reporting
services and sharepoint play well together.


[quoted text, click to view]

AddThis Social Bookmark Button