How To Install Microsoft SQL Server 2022: Change SQL Server Reporting Services maxRequestLength Setting

Microsoft SQL ServerThis article is part of the series on How To Install Microsoft SQL Server 2022; I do not claim to be an expert on SQL Server and this series is installing SQL Server in a development/testing/demo environment. If you’re installing SQL into a production environment there will be additional work required to harden the SQL Server and avoid security issues.

While I no longer work with Microsoft Dynamics GP, I am still cognisant of an error which occurs when deploying the GP SSRS reports. Because of this, I still generally make the required fix, just in case I work with a product which does similar and I can pre-emptively make sure I don’t get the error.

The setting, for SSRS 2022, is in C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer\web.config:

content of the web.config file

The highlighted section, above and below, needs to be added to the file on the httpRuntime line:

<httpRuntime executionTimeout="9000" requestValidationMode="2.0" maxRequestLength="20690" />

Once the section has been added, restart SSRS.

What should we write about next?

If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.

Your Name

Your Email

Suggested Topic

Suggestion Details

Leave a Reply

Your email address will not be published. Required fields are marked *