Click here to Skip to main content
15,892,746 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: , +
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.

XML
<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...
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900