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:
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: (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:
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!!!
Reporting Services Support Engineer