Can’t Activate Reporting Services Service in SharePoint

I upgraded SQL Server 2012 from RC0 to RTM today on a SharePoint application server which was configured for Reporting Services integration. The upgrade went with no errors but I got this error when requesting reports:

  • The requested service, ‘http://amatltapp02:32843/1dacf49a2f7a4a6daa8db5768539893f/ReportingWebService.svc’ could not be activated. See the server’s diagnostic trace logs for more information.
    • The requested service, ‘http://amatltapp02:32843/1dacf49a2f7a4a6daa8db5768539893f/ReportingWebService.svc’ could not be activated. See the server’s diagnostic trace logs for more information.

    And, when browsing directly the service:

    After some digging out, we solved the issue by changing the Enable 32-Bit Applications property of the IIS application pool for the SharePoint web application to False.

    031512_1512_CantActivat1

Server Error in ‘/1dacf49a2f7a4a6daa8db5768539893f’ Application.


The farm is unavailable.