Error “Maximum request length exceeded" in Reporting Services

If you ever find the following error in Reporting Services after uploading a file or creating a new subscription:    “Maximum request length exceeded”   There is a simple reason for that:   The default value of the property MaxRequestLength is 4 Mb. When you upload a report or create a subscription, if the report…

4

Can RS 2005 and RS 2008 coexist in the same machine?

  Yes, as long as:   1.       It is not Windows XP 32 2.       They are using different urls to connect to the RS 2005 and RS 2008.   Reporting Services 2008 and Reporting Services 2005 (IIS 6 or higher) can coexist in the same machine under most Operating Systems, without causing any conflicts between…

1

My email subscription doesn’t arrive to its destination

  The way that email subscriptions are processed is that the reports are sent to the pickup directory and then it is the SMTP server the one that finishes the process of sending it to the final user.   When your email (subscription) doesn´t arrive to its destination, want to distinguish if the problem is…

0

Troubleshooting Timeout errors in Reporting Services

Working with reports in Reporting Services, you can face timeout errors. This situation might happen when using very heavy reports. I will show bellow a list of different timeouts that could be affecting reports execution in Reporting Services and how you can adjust their values.   1.       If the timeout is produced by the query…

6

Recommendations for Uninstalling & Installing Reporting Services

  I am sure it has happen to all of us in some situations that we decided to uninstall Reporting Services and install it again.  Sometimes we make this decision because the state of Reporting Services is very unstable that it would take too long to troubleshoot the errors or because we want to restore RS to its…

2

Quick tips for monitoring and improving performance in Reporting Services

  In order to monitor the response times of the reports executed in Reporting Services, you need to understand how Reporting Services works concerning performance. You should know that there are 3 phases in the execution or a report:  “data retrieval” (time it takes to retrieve the data from the server using a queries or…

1

Reporting Services Resilience recommendations

  I found many people asking what the recommendations from Microsoft to make Reporting Services resilience are and if there is any plans for the future to make Reporting Services cluster aware.   As you can see from the following link, the installation of a complete report server installation in cluster is not supported:   Unsupported…

3

¿Have you ever thought of migrating to Reporting Services 2008… but you weren’t sure to expect?

  Before making the decision of migrating your Reporting Services 2000 or 2005 to 2008 (reports, models, data sources…) it is useful to consider the different scenarios that we might find, and understand the way Reporting Services upgrades the reports.   This article contains useful information that can help you to better plan the migration…

1