SSRS 2012 Service Application – Server was unable to process the request

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”>

<behavior name=”RSExecutionBehavior”>
     <serviceThrottling maxConcurrentCalls=”512″ maxConcurrentInstances=”512″ />
<serviceDebug httpHelpPageEnabled=”true” includeExceptionDetailInFaults=”true” />
</behavior>

 

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s