From now on, I will collect some interesting technical issues here. As you can see, I break down them into different buckets like SSRS, SSIS, SSAS, PowerBI, Powerpivot….
This thread starts the series on trouble shooting. (BTW, you will see “design tips” series too very soon.)
Well, this was an interesting issue because I never encountered it before even I have already SSRS or more than 7 or 8 years. Alright, let us talk about this issue.
Did you see this error before, see below screen shot?
RS complains “Maximum Request Length Exceed” when you deploy reports to RS portal. Actually, I like this error, pretty concise and specific, which is much better than some errors with a general verbage.
My gut feeling for this error is something wrong in file size as it says “Request length exceeded”, so let’s check out the file size of this RDL file. It is 5.8 MB, well, a little bit bigger than normal files.
What the default maximum value for uploading/deploying RDL file? 4MB. yes, it is 4 MB. That’s why I got that error.
How to resolve it? Add an attribute in the file “Web.config”. Steps as below,
Browse to the RS installation folder(“C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\”, you should see this file “web.config”. Open it and add(Yes, “ADD”. It was not there) the attribute as below
maxRequestLength=”500000″ in the section of “httpRuntime”. (this size depends on you. 500000 here works well for my case.) It is Kilobyte.
Now, someone would say you need to restart IIS to make sure this takes effect. Hum..really. It is right for SQL2000 and SQL2005 but it no longer be true after SQL2008(including SQL2008). My case, I am using SQL 2008 R2, it takes effect immediately after this change.
My friends, take care, have fun.