SQL Reporting Services Error- Maximum request length exceeded

September 16 | By Tracey Brinkman

Tags: | |

By Ryan McBee

When trying to deploy a large Dynamics GP report to your SSRS server or creating a subscription for one of your canned GP SSRS reports, you may run into an error like this:

Error 2 There was an exception running the extensions specified in the config file. —> Maximum request length exceeded.

Report Manager_Windows Internet Explorer

You could, quite honestly, run into this error in a lot of situations involving a web app, but we’re talking specifically about SSRS in this post. The basic problem here, is that your posting an amount of data to a web app larger than it is configured to accept.  Hence, it is throwing an error.

It’s an easy fix though.  You’ve got to adjust the web.config for the web app, which in the case of reporting server, is usually somewhere like this:

C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer

Find the web.config file for your reporting services instance, open it up, and track down the line that looks something like this

executionTimeout = “9000” />

Now just add a max request length attribute in there to fix the problem, adjust your size as needed.  This is 5meg.

executionTimeout = “9000” maxRequestLength=”500000″ />

And now you’ll need to restart IIS.  start->run->”iisreset”

Good luck!