SQL Reporting Services Error – Maximum request length exceeded

system center

Last updated on March 30th, 2023 at 07:01 pm

Read Time:1 Minute, 9 Second

When running or trying to create a large report in SSRS, you may come across an error stating the below:

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

SQL Reporting Services Error - Maximum request length exceeded 1

It took us a while to figure this one out but it is actually very simple. After speaking to our SQL and web development guys, it basically means that you are trying to pull more data than what the system is configured to allow. This is why you get the error, but it is simple to fix if you have a basic understanding of IIS.

You need to amend the web.config file on the reporting server which you should find in the location below unless you have installed it elsewhere:

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

Open the web.config file with notepad and then search for the following line:

<executionTimeout = “9000”>

After the 9000 text, you can add a maxRequestLength variable to allow more data to flow. 500000 equals 5mb:

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

The IIS service then needs to be restarted, so you can either restart the reporting server or type “iisreset” into a command prompt on the server.

Comments

If you have any questions or comments about this guide, please feel free to leave a comment below using our comments system.

Click to rate this post!
[Total: 0 Average: 0]

Free Subscription

If you want to be notified when we post more quality guides like this one, sign up to our free subscription service and you will receive an email when a new post is live.

Join 441 other subscribers.

No need to worry, we will not be filling your inbox with spam and you can unsubscribe anytime you like.


Leave us a message...

This site uses Akismet to reduce spam. Learn how your comment data is processed.