SQL Server Report Viewer on Application Server (IIS) for Asp.Net Application::
1. Install Report Viewer Distributed Patch on Application Server (in case database running on different machine and Asp.Net application running on different Machine with IIS)
2. Generate Database Server Machine Certificate, and Install on Application Server (in case database running on different machine and Asp.Net application running on different Machine with IIS)
3. Add the following lines in configuration file
<assemblies>
<!– Report assembly –>
<add assembly=”Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A” /> <add assembly=”Microsoft.ReportViewer.Common, Version=9.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A” />
</assemblies>
<buildProviders>
<add extension=”.rdlc” type=”Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.Common, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a” />
</buildProviders>
<system.webServer>
<validation validateIntegratedModeConfiguration=”false”/>
<modules>
<remove name=”ScriptModule”/>
<add name=”ScriptModule” preCondition=”managedHandler” type=”System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35″/>
</modules>
<handlers>
<add name=”Reserved-ReportViewerWebControl-axd” path=”Reserved.ReportViewerWebControl.axd” verb=”*” type=”Microsoft.Reporting.WebForms.HttpHandler” resourceType=”Unspecified” />
</handlers>
</system.webServer>
Enjoy!!