Sunday, July 17, 2011

SSRS: The deployment has exceeded the maximum request length allowed by the target server

Earlier today, I was deploying SQL Server Reporting Services (SSRS) reports for a client who just upgraded from version 9 to version 2010 R2 on Microsoft SQL Server 2008 R2. Upon beginning the deployment, the following error came up:

maxRequestLength error deploying BI reports

The error and it's resolution are pretty clear and called for setting the maxRequestLength attribute to "20690" in SSRS's web.config file.

Web.config

The SSRS web.config file can typically be found under the %programfiles%\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\Report Server, for a Microsoft SQL Server 2008 R2 SSRS installtion done in Native mode. If you have other types of deployments, for example, SharePoint integrated, it will be necessary to consult with your system administrator.

You can then proceed to use Visual Studio or, simply, Notepad to edit the web.config file, locating the httpRuntime element of the XML document.

web.config - httpRuntime section

The final edit of this section should look like this, with the maxRequestLength attribute added.

web.config - Edited httpRuntime section with maxRequestLength parameter

Once the web.config file was saved, I reinitiated the deployment and all was well. The maxRequestLength attribute specifies the maximum upload size for a file into the SSRS reports library in kilobytes. For this specific instance, 20,690 seems to be the magical number.

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.intellpartners.com/

13 comments:

Kumar said...

Mariano, Great post with screenshots. The same issue has been summarized in Daoud's article in his blog http://mohdaoud.blogspot.com/2011/04/dynamics-gp-2010-r2-business.html.

Raja said...

this is very valuable information. Thank you for posting this.

victoriayudin.com said...

Thanks Mariano,

Nice to find a solution at 4am, all spelled out, with screenshots and exactly what I needed to fix the error I was seeing. You're the best!

-Victoria

Anonymous said...

Thank you for posting this. but I am still getting the same error. Do I have to increase the Max length?

-

OV said...

Great post. To the point and very handy. I couldn't find the resolution on MS, especially with new knowledgebase:(

Kaustubh Ghanekar said...

Helpful. Thanks.

Emil said...

This worked great for a prototype install on my laptop, but I had to restart the SSRS service before the installation would succeed. Thanks for the concise solution - I was going to go nuts trying to figure out where that maxRequestLength setting belonged!

Jeff Morlen said...

BTW: This is the fix that needs to be applied when you implement SSRS from SQL2012 with GP2013 as well.

Mariano Gomez said...

Jeff,

This "fix" is needed for every GP SSRS reports deployment, regardless of database server and GP release.

MG.-
Mariano Gomez

Belinda Allen said...

I use this post frequently Mariano. Thanks for putting it out there!

Belinda

Steve Chapman said...

You saved me again, Mariano. Thanks.

Mariano Gomez said...

@Belinda and @Steve,

I may need to start charging royalties for this post, he, he!

Anonymous said...

Excellent! I need to bookmark your blog. Thank you for a fast and easy resolution to this issue.