Thursday, 31 May 2012

Failed to load expression host assembly. Details: Could not load file or assembly 'Microsoft.EnterpriseManagement.Reporting.Code, or one of its dependencies. Failed to grant minimum permission requests.(rsErrorLoadingExprHostAssembly)

Got this error in SSRS reports containg SCSM 2012 reports performed the following steps and it resolved the issue for me.

Logon to the SSRS server

1)       Copy the Microsoft.EnterpriseManagement.Reporting.Code.dll file from the prerequisite folder of SCSM 2012 Installation media and place it in a folder
2)      Drag and Drop Microsoft.EnterpriseManagement.Reporting.Code.dll  here

C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\Bin.

3)        Add a code segment to the Rssrvpolicy.config file
4)      Navigate to C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer.
5)      Open the Rssrvpolicy.config file.
6)      Scroll through the Rssrvpolicy.config file and locate the CodeGroup code segments. The following code shows an example of a CodeGroup segment.
   class="UnionCodeGroup"
   version="1"
   PermissionSetName="FullTrust">
   <IMembershipCondition
      class="UrlMembershipCondition"
      version="1"
      Url="$CodeGen$/*"
   />
</CodeGroup>

7)      Add the following CodeGroup segment to the same section as the other CodeGroup segments in the Rssrvpolicy.config file.
<CodeGroup
   class="UnionCodeGroup"
   version="1"
   PermissionSetName="FullTrust"
   Name="Microsoft System Center Service Manager Reporting Code Assembly"
   Description="Grants the SCSM Reporting Code assembly full trust permission.">
   <IMembershipCondition
      class="StrongNameMembershipCondition"  
      version="1"
      PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000100B5FC90E7027F67871E773A8FDE8938C81DD402BA65B9201D60593E96C492651E889CC13F1415EBB53FAC1131AE0BD333C5EE6021672D9718EA31A8AEBD0DA0072F25D87DBA6FC90FFD598ED4DA35E44C398C454307E8E33B8426143DAEC9F596836F97C8F74750E5975C64E2189F45DEF46B2A2B1247ADC3652BF5C308055DA9"
/>
</CodeGroup>
8)      Close and save the changes.
9)      Stop and Start SSRS Service


3 comments:

  1. Hi there еѵerу one, herе evегу pеrson is sharing such exрeriеnce, theгеforе іt's nice to read this weblog, and I used to visit this website every day.
    Also see my webpage > captcher

    ReplyDelete
  2. Just desire to say your article is as astounding.
    The clearness in your post is simply cool and i can assume
    you're an expert on this subject. Well with your permission allow me to grab your feed to keep updated with forthcoming post. Thanks a million and please carry on the gratifying work.
    My web-site ; Folgers Coffee Coupons

    ReplyDelete
  3. I don't write a bunch of comments, but i did some searching and wound up here "Failed to load expression host assembly. Details: Could not load file or assembly 'Mіcгosoft.
    ΕnterpriseManagеment.Rеporting.Code, or one of its dependenсіes.
    Failed to grant minimum рermіssion requests.
    (rsΕrгorLοadingΕхprHоstAssemblу)". And I actually do have some questions for you if it's allright. Could it be only me or does it look like a few of these remarks look as if they are coming from brain dead individuals? :-P And, if you are posting at additional sites, I'd like to keep up with anything new you have to post. Would you list of all of your community pages like your twitter feed, Facebook page or linkedin profile?
    Take a look at my weblog - seonuke

    ReplyDelete