SQL Reporting Services Error – Maximum request length exceeded

Last updated on September 25th, 2021 at 09:09 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.

SQL Reporting Services Error - Maximum request length exceeded 2

About Post Author

A.J. Armstrong

Founder of TechyGeeksHome and Head Editor for over 12 years! IT expert in multiple areas for over 22 years. Sharing experience and knowledge whenever possible! Making IT Happen.
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 453 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.

apple logo Previous post Apple Release iOS 8.2
TGH Word Cloud Next post Gaming Geeks Home – Website Merge