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 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. (the issue already appeared in the past and was solved by http://support.microsoft.com/kb/936707/en-us)   Why is this happening? When a .NET application startup the…

6

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

  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 HTTPservice located at http://MACHINE:32843/a49407bfb2c3432e9953dc831d8b0a0f/ReportingWebService.svcis too busy. The HTTPservice located at http:// MACHINE:32843/a49407bfb2c3432e9953dc831d8b0a0f/ReportingWebService.svcis too busy. The remoteserver returned an error:…

1

"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 might find yourself with the following error:  “Arithmetic operation resulted in an overflow”   The StackTrace would be the following: System.Data.Odbc.OdbcStatementHandle.RowCount(System.Data.Odbc.SQLLEN ByRef) System.Data.Odbc.OdbcDataReader.GetRowCount() System.Data.Odbc.OdbcDataReader.FirstResult() System.Data.Odbc.OdbcCommand.ExecuteReaderObject(System.Data.CommandBehavior,System.String, Boolean, System.Object[], SQL_API) System.Data.Odbc.OdbcCommand.ExecuteReaderObject(System.Data.CommandBehavior,System.String, Boolean) System.Data.Odbc.OdbcCommand.ExecuteReader(System.Data.CommandBehavior) System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(System.Data.CommandBehavior) System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(System.Data.CommandBehavior) Microsoft.ReportingServices.DataExtensions.CommandWrapper.ExecuteReader(Microsoft.ReportingServices.DataProcessing.CommandBehavior) Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunDataSetQuery() After struggling to find…

0

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 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 / Programs And Features Select“Microsoft SQL Server 2012 RS Add in for SharePoint”              You…

0

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 different combinations that are compatible with this new version concerning databases, BIDS, Report Viewer, SharePoint and PowerPivot. It is mostly compatible with prior versions, incompatibilities revolve around loss of support for SQL Server 2000, BIDS 2000 and…

0

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 & 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 Reporting Services with SharePoint 2010. You observe that there is a Big different…

2

ERROR: Execution ‘<ID>’ cannot be found (rsExecutionNotFound)

  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 the use of an NLB. Execution ‘<ID>’ cannot be found (rsExecutionNotFound)   TROUBLESHOOTING:…

4

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 Reporting Services 2008 R2 after moving the Reporting Services databases to another computer (http://technet.microsoft.com/en-gb/library/ms156421.aspx) Error: "An internal error occurred on the report server. See the error log for more details. (rsInternalError) Invalid object name ‘ReportServerTempDB.dbo.PersistedStream’."   The most…

1

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 on a separate machine, and windows integrated security, you have either of the two following possibilities: 1. Enabling Kerberos In this configuration with Microsoft Dynamics CRM on one server, and Microsoft SQL Server and Reporting Services on another,…

0