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.