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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics