SQL Server 2008 R2 SSRS Integrated into Sharepoint Error

• mtassin

  SSC-Insane

  Points: 23099

  More actions

  June 2, 2010 at 2:35 pm

  #225221

  Hey all,

  I've managed to setup Windows 2008 R2, Sharepoint 2010, SQL Server 2008 R2 EE, and publish a report model to it from BIDS 2008 R2.

  When I go into Report Builder 3.0 I can generate a Data Set, and configure a simple report. When I try to run the report I get the following error.

  Failed to load expression host assembly. Details: Could not load file or assembly 'expression_host_b12110c64b1245d39a41b8ff3916f98c, Version=12.2.1600.1, Culture=neutral, PublicKeyToken=null' or one of its dependencies. Failed to grant permission to execute. (Exception from HRESULT: 0x80131418) (rsErrorLoadingExprHostAssembly)

  Any idea of what I need to look for on this one? I have no idea what I need execute permissions on at this point.

  ---

  
  --Mark Tassin
  MCITP - SQL Server DBA
  Proud member of the Anti-RBAR alliance.
  For help with Performance click this link[/url]
  For tips on how to post your problems[/url]

• truby

  Grasshopper

  Points: 15

  More actions

  October 31, 2011 at 8:40 pm

  #1401396

  Hi,

  I have the same problem, when trying to build a report off an access database.

  did you ever get through this problem?

  Truby

• sakbar 54467

  Newbie

  Points: 7

  More actions

  March 8, 2012 at 2:34 pm

  #1456823

  Hey, did anyone manage to figure this out? I'm running in to the same problem, and it's quite frustrating!