This 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:
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.
Click to show/hide the How To Install Microsoft SQL Server 2022 Series Index
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.