Sometimes it can be useful to restart Reporting Services automatically using a script to avoid the initialization time it takes to start Reporting Services the first time it is being accessed, or to control the recycle process of the web service. ...

When using a load balancer with several nodes in Reporting Services, you might notice that the Report Server ( http://<machinename>/Reportserver ) is accessible but Report Manager ( /Reports">http://<machinename>/Reports ) produces the following...

It is possible to send a email subscriptions in Reporting Services to recipients that are outside the domain (on the internet). You would need to setup the following configurations: First of all, you might receive the following error when the e...

If you are using Reporting Services and Integration Services and you noticed that the service couldn't start after the installation of the MS12-070 security patch ( http://support.microsoft.com/kb/2716429 ) you can use the following 2 workarounds below...

Playing around with the SharePoint integration with the new Addin of Reporting Services 2012 I suddenly found myself with the following error while running a report that used to work perfectly before: Error The HTTP service located at http:/...

If you are using Reporting Services to create reports that connects to your Oracle 10 server, you might find yourself with the following error: "Arithmetic operation resulted in an overflow" The StackTrace would be the following: System.Data...

Where is my Add-in of Reporting Services for SharePoint? I need to find out which version I installed. Did I install the riht version or the Service Pack? You can check this in a very easily in the installed programs list: Open: Control Panel...

Do you want to install/upgrade to the new version of Reporting Services 2012? You can see below the different combinations that are compatible with this new version concerning databases, BIDS, Report Viewer, SharePoint and PowerPivot. It is mostly...

I discovered short time ago a simple way to improve performance of certain Reports (RS 2008 & 2008 R2) running in integration with SharePoint 2010. Imagine the following scenario: You are using SQL Server Add-in 2008 or 2008 R2 to integrate...

I would like to share with you usefull information to troubleshoot the following error in Reporting Serices native or integrated with SharePoint mode, in case you find it in your environment. Sometimes, the error can be random, and sometimes, caused by...

  I decided to share this information in case this happens to you when running reports in Reporting Services 2008 R2 after moving the Reporting Services databases to another computer ( http://technet.microsoft.com/en-gb/library/ms156421.aspx ) Error...

When using Microsoft Dynamics CRM to run reports from a Reporting Services server that is installed on a separate machine, and windows integrated security, you have either of the two following possibilities: 1. Enabling Kerberos In this configuration...

I would like to share with you an issue I had running reports from CRM 4.0 and getting the error “The 'CRM_FullName' parameter is missing a value” In case you find yourselves in the same situation, doing a lot of troubleshotting on parameters...

The long waited Cumulative Update 7 for Reporting Services 2008 R2 is finally out. The product team has worked very hard to include some performance fixes related to the new inclusion of Ajax functionality in this version. Some of the fixes bellow...

We get many cases trying to configure Reporting Services with SharePoint. I am creating this post because some of the errors on the configuration can be avoided by choosing the right versions of the Add in (and service packs) depending on the versions...

Short time ago we found the following error when running Reports randomly in a web farm: Validation of view state mac failed, this application is hosted by a web farm or cluster, ensure that machine key configuration specifies the same validation...

Due to the great confusion I perceive about this error and its possible causes and solutions, I decided to remove my 3 old posts that talked about this error and create a single and more complete posts that I hope helps you resolve all the possible causes...

Before Service Pack 3, fonts weren´t embedded in the PDF file after when rendering the report to this format. The side effect is that the size of the file might be bigger. Some people have asked if it is possible to revert back to the old behavior...

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...

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...

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...

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...

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...

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...

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...