I have built big custom Web reports with SQL views and if running on default SCCM settings you will soon get HTTP 500 errors in web reporting page since the IIS buffers reaches the limit.
First open latest IIS log file in trace32:
<drive>:\inetpub\logs\LogFiles\W3SVC1
Then Run the failing report again and check status in log.
I got this error:
ASP_0251_:_80004005 Response_Buffer_Limit_Exceeded
This means that the IIS buffers needs to be increased from the default value 4MB.
Open IIS management console and select SMSReporting_<sitecode>
Open ASP feature
Adjust the buffer limit by counting 2MB for each 500 rows in the report. I put 40MB of memory (4MB is default).
I also adjusted the Time-out value to 5 minutes.
Restart IIS service.
This solved my HTTP 500 problems since I got the
“ASP_0251_:_80004005 Response_Buffer_Limit_Exceeded”
error in the IIS log. Other errorcodes might hade other solutions.