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://MACHINE:32843/a49407bfb2c3432e9953dc831d8b0a0f/ReportingWebService.svc
is too busy.

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

The remote
server returned an error: (503) Server Unavailable. 

 

I know the password of my account had changed by after correcting it in the application pools in IIS and in Central Administration under managed accounts, the error persisted and I couldn’t get it to work again.

I finally fixed it by re-provision the Reporting Services Service Application.

I am sharing the steps I used in PowerShell:

 

  •  First of all you need to open the SharePoint Management Shell to be able to run cmdlets:

 (From) http://msdn.microsoft.com/en-us/library/gg492249.aspx

  1. Type the following command from the SharePoint 2010 Management Shell:
  2. Click the Start button
  3. Click the Microsoft SharePoint 2010 Products group
  4. Click the SharePoint 2010 Management Shell.

 

    • These are the commands run in SharePoint Management Shell console:

     

    1. To Get all the Reporting Services service applications run the following command:

     Get-SPRSServiceApplication

      
     
      
      
      In my case, I only had one that corresponded to the ID of the error, although you could have several

     

     2. Then run the two commands:

     

    $sts = Get-SPRSServiceApplication

    $sts.Provision()


     

    And the report started working again!!!

     

     

     

    Maria Esteban

    Reporting Services Support Engineer