I have set up a development server for project testing. The server is windows 2012 with SQL Server 2012 and Reporting Services Installed. Each developer has a local file system on their machine that they can edit, save, and then view on their specific site on the dev server (IIS hosting each developer's local file system as a virtual directory). The development server is a replication of our live server. Each developer is on a different port and IIS has a different website for each developer pointing to their local directories. Everything seems to be working great except for our reports. Whenever I try to run a report I get this error.
"An error occurred during local report processing.
Failed to load expression host assembly. Details: Could not load file or assembly 'Microsoft.ReportViewer.Common, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Access is denied."
When I run the site off of the development server on its own directory the report runs fine. Is it looking for the dll on my local machine? If so is there a way I can have it look on the server? I have a web.config file that adds the ReportViewer assemblies.
<assemblies>
<add assembly="System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
<add assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
<add assembly="System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
<add assembly="System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
<add assembly="Microsoft.ReportViewer.Common, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
<add assembly="Microsoft.ReportViewer.WebForms, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
</assemblies>
I have Report Viewer Runtime 2012 and SQL Server CLR Types installed both on the server and on the local machine. The Microsoft.ReportViewer.Common.dll and Microsoft.ReportViewer.WebForms.dll (both version 11) are located on C:\windows\assembly\GAC_MSIL\
Is there anything you can think of to be able to run these reports? Thanks for the help! Let me know if you would like any more details/code/etc...