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:



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

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:


  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:


      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



    And the report started working again!!!




    Maria Esteban

    Reporting Services Support Engineer