Report Viewer error: The request failed with HTTP status 401: Unauthorized

asp.netreportreportviewerSecurity

I have a asp.net c# web application with contains reports in remote processing mode. I am using the report-viewer control to render the reports. When I run the application in debug mode, I'm able to view my reports however when I publish the application to a different server I get this error message:

The request failed with HTTP status 401: Unauthorized.

My report server is on a different server than the location of my published web application. I have added new role assignment to my report server and also added to my web.config but the error persists. I think I am missing something in my aspx page for reportviewer.

Any input would be appreciated.

Best Answer

I'm assuming you already have set the server in your codebehind such as this

reportviewer.ServerReport.ReportServerUrl = "http://{server_ip}/reportserver";

or via the properties of the report viewer control. Make sure you change {server_ip} to the actual for the report server.

Other such problems I've seen in the past have to do with access for individual reports. Since this is cross-server, you'll need a proxy user set to view the reports.

Here are 2 examples from MSDN:

Example 1

Example 2

Related Solutions

Visual-studio – Using different Web.config in development and production environment

In Visual Studio 2010 and above, you now have the ability to apply a transformation to your web.config depending on the build configuration.

When creating a web.config, you can expand the file in the solution explorer, and you will see two files:

Web.Debug.Config
Web.Release.Config

They contain transformation code that can be used to

Change the connection string
Remove debugging trace and settings
Register error pages

See Web.config Transformation Syntax for Web Application Project Deployment on MSDN for more information.

It is also possible, albeit officially unsupported, to apply the same kind of transformation to an non web application app.config file. See Phil Bolduc blog concerning how to modify your project file to add a new task to msbuild.

This is a long withstanding request on the Visual Studio Uservoice.

An extension for Visual Studio 2010 and above, "SlowCheetah," is available to take care of creating transform for any config file. Starting with Visual Studio 2017.3, SlowCheetah has been integrated into the IDE and the code base is being managed by Microsoft. This new version also support JSON transformation.

C# – An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode

The 2^nd option is the one you want.

In your web.config, make sure these keys exist:

<configuration>
    <system.webServer>
        <validation validateIntegratedModeConfiguration="false"/>
    </system.webServer>
</configuration>

Best Answer

Related Solutions

Visual-studio – Using different Web.config in development and production environment

C# – An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode

Related Topic