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.
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.
If you have any questions or comments about this guide, please feel free to leave a comment below using our comments system.
Enter your email address below and click the Subscribe button to receive email notifications about new and exciting downloads available through our website at https://www.techygeekshome.com
You will also receive notifications about new technical guides, latest news and MSI installer downloads that are available through our blog here at https://blog.techygeekshome.info
We will not spam you and we will not pass on any of your details to anyone else. We tend to post new content once or twice a week.
You can unsubscribe any time you like.