IIS 6.0 - Configuration - Increasing the ASPBufferingLimit Value (SMS 2003 Reporting)
With fairly large SMS 2003 web reports, I've received memory errors. Although I had increased the number of rows necessary to produce the correct records, (see http://myitforum.com/cs2/blogs/mlucero/archive/2007/05/17/sms-2003-configuration-increasing-rows-past-10-000-in-web-reporting.aspx), I still could not view the report I had created. This will be most noticeable in larger SMS environments but may occur in smaller situations, depending upon the size of the web report. The following resolution is from Microsoft:
"You might need to adjust the AspBufferingLimit setting. The AspBufferingLimit property sets the maximum size of the ASP buffer. The default is approximately 4 MB. To change the default, open %WindowsRoot%\System32\InetSrv\MetaBase.xml and search for “AspBufferingLimit”. Adjust the setting to allow for 1 MB per 1000 records. You can make changes to the MetaBase.xml file while IIS is running only if the edit-while-running feature is enabled. Otherwise, you must stop IIS before editing the MetaBase.xml file.
For more information about writing changes to MetaBase.xml, see “Configuring the Metabase” in the Server Administration Guide on Microsoft TechNet."
The section of the MetaBase.xml file you need to find is: </IISFtpServer>
Then, search for the value: AspBufferingLimit="[some number]"
I changed the value in our MetaBase.xml file to 80194304 and it works just for for all our reports. As a reference we have 13,000+ clients. I hope this is helpful to other folks. Here is the link to the Q & A: http://www.microsoft.com/technet/sms/2003/library/techfaq/tfaq10.mspx