Deploying a custom assembly to the Reporting Server

• ian williams-212646

  SSC Veteran

  Points: 209

  More actions

  January 26, 2007 at 3:15 am

  #116038

  I'm having a load of grief trying to correctly deploy a custom assembly I wrote to the Reporting Server and get a #Error on a report where I call my custom code.

  The assembly acts as a wrapper to a web service we already had and works within the report designer IDE, returning the correct data in preview mode.

  I have added the AllowPartiallyTrustedCallers attribute into the Assemblyinfo with the following syntax:

  [assembly: AllowPartiallyTrustedCallers]

  and have also added the following security assert into the classes header:

  [UrlIdentityPermissionAttribute(SecurityAction.Assert, Url = "http://xxxx/PeopleFinderWS/PFWS.asmx")]

  I've compiled the assembly and saved the dll into the following folder on the Report Server:

  C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\bin

  and have added the following code group to the rssrvpolicy.config on the same server immediately below the $CodeGen$/* code group:

  I presume I'm doing something stupid or have left out something obvious but I've been looking at this problem for a day and a half just to get to the stage I'm at now, any help would be much appreciated.

  Any ideas?