Error while deploying the shrepoint delivery extensions on Report server 2005
Trying to deploy the the delivery extensions as per the article
http://msdn.microsoft.com/en-us/magazine/cc163633.aspx
Error:
Could not load file or assembly 'SPSLibraryDelivery' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
I am using Report Server 2005 and below are the steps i follow
The following document details how to deploy the sample solution discussed in the article. All the files needed for deployment specific to this solution are located in the Deployment folder. The file system paths notes here are based on the default installation
options of both SQL Server 2000 Reporting Services and SharePoint Portal Server 2003.
Deploying the Delivery Extension
The following steps should be taken to deploy the custom delivery extension. For more details on why these steps are necessary, read the MSDN article at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_extend_deliver_83j6.asp.
<Extension Name="SPS Library Delivery" Type="Sample.SPSLibraryDelivery.SPSLibraryDeliveryProvider,SPSLibraryDelivery">
<Configuration></Configuration>
</Extension>
Modify the rssrvpolicy.config file located in the same folder to grant permissions to your assembly. The following should be placed right after the FirstMatchCodeGroup for the MyComputer zone.
<CodeGroup class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="CustomDeliveryExt"
Attributes="Exclusive, LevelFinal"
Description="Codegroup generated by the .NET Configuration tool">
<IMembershipCondition class="StrongNameMembershipCondition"
version="1"
PublicKeyBlob="002400000480000094000000060200000024000052534131000400000100010
09FAABCDEE890E0B1250D0A9055A46FFA85BBABFE416BCD92658F99C7DE4D383DF12E7493A5717CD
17F042BF75564B03F997979B65DAFC2AF3DA845F5AD8A02F71C0E706B491D0AC575CFC72116B448939
4044DE9E0A718ECA29AB5AAF0B178699A702F8C2492CBFED8281677BD3247DD2B4F11FCA73CF441B3776
D2BFA6B7DC5"
/>
</CodeGroup>
Also, I had to modify the FirstMatchCodeGroup for the MyComputer Zone to also run with FullTrust or the service that called my assembly wouldn’t be granted enough permissions. This should be the code group right above the one you inserted.
Copy the SPSLibraryDelivery.dll assembly to C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\Bin.
Add an entry into the DeliveryUI element of the RSWebApplication.config file located at C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager.
<Extension Name="SPS Library Delivery" Type="Sample.SPSLibraryDelivery.SPSLibraryDeliveryUIProvider,SPSLibraryDelivery"/>
Make the same code access security changes you made in steps 3&4 to the rsmgrpolicy.config file locate at C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager.
Restart the ReportServer Windows Service.
Copy the SPSLibraryDelivery.dll assembly to C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin.
Modify the Delivery element of the RSReportServer.config file located at C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer:
Deliver SQL Reports to SharePoint Deployment Guide
November 24th, 2010 4:57pm
Hi Nitsmooth,
The error "Could not load file or assembly 'SPSLibraryDelivery' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)" occurred because of the customized deliver
extension(download from the article you mentioned) is designed for SQL Server Reporting Services(SSRS) 2000. It add references to SSRS 2000 assembly(Microsoft.ReportingServices.Interfaces, version 8..0.242.0), which is no longer available in SSRS 2005.
In order to solve the issue, we need to re-design the delivery extension by ourself.
If there is anything unclear, please feel free to ask.
Thanks,
Jin ChenJin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
November 26th, 2010 3:16am