In this short series of posts, I am going to be covering the installation of Microsoft SQL Server 2017; the installation process for this version is somewhat different to previous ones, in that SQL Server Management Studio and SQL Server Reporting Services have been separated out from the main installer.
The series index can be found here. I am not a SQL expert and this series of posts is intended only for use on demo or test environment and not production ones.
In the last post I configured SSRS, which is fine for most uses. However, Microsoft Dynamics GP requires an additional configuration step. This is not done through the Report Server Configuration Manager, but by editing a config file.
The reason this is required is because of an error produced when deploying the SSRS reports. If you do not change the setting, the error you will receive is the following:
Microsoft Dynamics GP
The deployment has exceeded the maximum request length allowed by the target server. Set maxRequestLength="20690" in the web.config file and try deploying again.
To avoid this error, requires the SSRS web.config file to be amended. The file, for SQL Server Reporting Services 2017, is located in
C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer.
Below is a snippet of code from the web.config file with the added node highlighted:
<httpRuntime executionTimeout="9000" requestValidationMode="2.0" maxRequestLength="20690" />
Add the above, save the file, and SSRS is now ready for the Microsoft Dynamics GP reporting services reports to be deployed.