After installing and configuring SSRS 2012 in SharePoint integrated mode, I received the following error when trying to do, well, anything with the service:
“The server was unable to process the request due to an internal error…”
The SharePoint error logs were no help, so I did what the error suggested.
1. Opened the web.config file for the SSRS Service Application. Default location is:
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\WebServices\Reporting
2. Followed the instructions here to modify the file to enable the actual error to be displayed in the browser, which are:
a. Find the following sections, and add the parts in bold:
<service name=”Microsoft.ReportingServices.ServiceRuntime.ReportServiceManagement” behaviorConfiguration=”RSExecutionBehavior”>
<serviceThrottling maxConcurrentCalls=”512″ maxConcurrentInstances=”512″ />
<serviceDebug httpHelpPageEnabled=”true” includeExceptionDetailInFaults=”true” />
After that was done, the following message appeared (which was then easily fixed):
Just remember to undo those config changes on anything other than a dev box, for security reasons.