HowTo: Adjust the web.config for Reporting Services

If you want to use Microsoft SQL Reporting Services in your Silver Essence Portal, it requires some additional entries in your web.config. If you install the Silver Essence Framework after today (January 4th, 2017) you will automatically have these entries. If you have an installation from before this date, and you want to use Microsoft SQL Reporting Services, here's what you will have to change to your web.config.

System.Web, Compilation, Assemblies

Open the web.config using a text editor like Notepad. In the System.Web, Compilation, Assemblies you have to add the following lines:

<add assembly="Microsoft.ReportViewer.WebForms, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845DCD8080CC91"/>
<add assembly="Microsoft.ReportViewer.Common, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845DCD8080CC91"/>
<add assembly="Microsoft.Build.Framework, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>

System.Webserver, Handlers

Scroll down to System.Webserver, Handlers and add the following line:

<add name="ReportViewerWebControlHandler" preCondition="integratedMode" verb="*" path="Reserved.ReportViewerWebControl.axd"
type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />

When changing the web.config

As with all changes to the web.config, be sure to make a backup of the current version. Also, keep in mind that changes to the web.config will trigger the application to recycle. Effectively this means that all current sessions will be reset and active users will have to login again. Any changes they were making will not be saved. So it is best to do such changes during an announced maintenance window.