Sunday, 1 November 2015

SSRS Error: Maximum request length exceeded.


Maximum request length exceeded:
         By default we can Deploy/Upload a report with maximum size 4 MD, into ReportManager. When we try to Deploy/Upload a report more than 4 MB size, then we will get the error “Maximum request length exceeded”.

Error During deploy:

Error while uploading:

Solution:
         We can increase the default size by updating the "Web.config" in the below two locations.
  1. %\Program Files\Microsoft SQL Server\MSSQL.X\Reporting Services\ReportManager
  2.  %\Program Files\Microsoft SQL Server\MSSQL.X\Reporting Services\ReportServer

  • Edit the “Web.config” file.
  •  Go to the tag “<httpRuntime executionTimeout="90000" />”.

  • Update the tag with required length
               <httpRuntime executionTimeout="90000" />


  • Save the file
  • Restart the SSRS Service.