Maria's two cents

Building a script to restart REPORTING SERVICES automatically

Sometimes it can be useful to restart Reporting Services automatically using a script to avoid the...

Author: Maria Esteban Date: 05/14/2013

Error 401 accessing the Report Manager in an environment configured in Scale Out

When using a load balancer with several nodes in Reporting Services, you might notice that the...

Author: Maria Esteban Date: 01/23/2013

Configuring Reporting Services to send email subscriptions outside the organization

It is possible to send a email subscriptions in Reporting Services to recipients that are outside...

Author: Maria Esteban Date: 01/04/2013

Reporting Services service doesn't start after the installation of MS12-070 security patch

If you are using Reporting Services and Integration Services and you noticed that the service...

Author: Maria Esteban Date: 11/12/2012

The HTTP service located at https://MACHINE:32843/a49407bfb2c3432e9953dc831d8b0a0f/ReportingWebService.svc is too busy

Playing around with the SharePoint integration with the new Addin of Reporting Services 2012 I...

Author: Maria Esteban Date: 10/30/2012

"Arithmetic operation resulted in an overflow" Error running a report that uses a connection data source to Oracle 10

If you are using Reporting Services to create reports that connects to your Oracle 10 server, you...

Author: Maria Esteban Date: 07/05/2012

How can I check the version of the Add-In of Reporting Services for SharePoint I have installed?

Where is my Add-in of Reporting Services for SharePoint? I need to find out which version I...

Author: Maria Esteban Date: 06/13/2012

Reporting Services 2012 Inter-Version Supportability

Do you want to install/upgrade to the new version of Reporting Services 2012? You can see below the...

Author: Maria Esteban Date: 04/25/2012

Improving performance of reports (for Reporting Services 2008 & 2008 R2) integrated with SharePoint 2010 by using the SQL Server 2012 Add-in

I discovered short time ago a simple way to improve performance of certain Reports (RS 2008 &...

Author: Maria Esteban Date: 04/23/2012

ERROR: Execution '' cannot be found (rsExecutionNotFound)

I would like to share with you usefull information to troubleshoot the following error in Reporting...

Author: Maria Esteban Date: 03/21/2012

Reporting Services error: “RSInternalError: Invalid object name 'ReportServerTempDB.dbo.PersistedStream'."

  I decided to share this information in case this happens to you when running reports in...

Author: Maria Esteban Date: 02/23/2012

Reporting Services 2008 R2 and CRM 2011 Windows authentication using separate machines

When using Microsoft Dynamics CRM to run reports from a Reporting Services server that is installed...

Author: Maria Esteban Date: 02/02/2012

The 'CRM_FullName' parameter is missing a value

I would like to share with you an issue I had running reports from CRM 4.0 and getting the error...

Author: Maria Esteban Date: 10/24/2011

Reporting Services 2008 R2 – Performance improvements with CU7

The long waited Cumulative Update 7 for Reporting Services 2008 R2 is finally out. The product team...

Author: Maria Esteban Date: 04/26/2011

Compatibility and Supported combinations for the integration of Reporting Services 2008 with SharePoint 2007 and 2010

We get many cases trying to configure Reporting Services with SharePoint. I am creating this post...

Author: Maria Esteban Date: 10/19/2010

“Validation of view state mac failed” Error in Reporting Services

Short time ago we found the following error when running Reports randomly in a web farm: Validation...

Author: Maria Esteban Date: 08/18/2010

Error “Unable to load client print control” when printing reports in Reporting Services (summary of possible causes and solutions)

Due to the great confusion I perceive about this error and its possible causes and solutions, I...

Author: Maria Esteban Date: 04/13/2010

How to disable this Font embedding in Reporting Services 2005 Service Pack 3?

Before Service Pack 3, fonts weren´t embedded in the PDF file after when rendering the report to...

Author: Maria Esteban Date: 04/12/2010

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

Author: Maria Esteban Date: 12/23/2009

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

Author: Maria Esteban Date: 10/13/2009

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

Author: Maria Esteban Date: 10/13/2009

Troubleshooting Timeout errors in Reporting Services

Working with reports in Reporting Services, you can face timeout errors. This situation might happen...

Author: Maria Esteban Date: 09/24/2009

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

Author: Maria Esteban Date: 07/10/2009

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

Author: Maria Esteban Date: 04/16/2009

Reporting Services Resilience recommendations

I found many people asking what the recommendations from Microsoft to make Reporting Services...

Author: Maria Esteban Date: 04/01/2009

Using the API of Reporting Services to render reports to Excel or PDF in a multi language environment.

You might find yourself in a situation in which you want to use the API of Reporting Services to...

Author: Maria Esteban Date: 03/17/2009

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

Author: Maria Esteban Date: 01/29/2009

Report Server cannot start after installing MS08-040 or MS08-052

If you install MS08-040 or MS08-052 and you find that the Report Server cannot start any more, you...

Author: Maria Esteban Date: 10/31/2008

How to change the version of Reporting Services 2005 from 64 bits to 32 bits?

Have you ever been in a situation that you installed Reporting Services in a 64 bits machine and...

Author: Maria Esteban Date: 09/05/2008

Querying SharePoint List from Reporting Services returns only “not null” columns

Querying to a Sharepoint List from a report in Reporting Services 2005 returns only the columns that...

Author: Maria Esteban Date: 12/13/2007

SSL configuration and Reporting Services

When installing Reporting Services 2005 with Secured Socket Layer (SSL), it is a common mistake not...

Author: Maria Esteban Date: 12/12/2007

Reporting Services Internal Error

Over the last months I have bumped into many occurrences of the following error in machines that are...

Author: Maria Esteban Date: 12/10/2007