SharePoint Content Service is null (SSRS & SP Integration)

Question

I'm having a problem setting up the integration between SSRS and SharePoint 2010.

1 server: SQL 2008 R2 SP1, Sharepoint 2010 SP1. The server is also a domain controller...
The Reporting Services Add-on for Sharepoint was already installed on the server, but I reinstalled it, and it is visible in Central Administration.
SSRS service is running as a domain user, and all application pools are running as domain users (SSRS and app pool users are different)
SSRS database is in SharePoint integrated mode.

When configuring Reporting Services in Central Administration, I can perform "Report Service Integration" and "Add a Report Server to the Integration". I cannot verify if the "Add a Report Server.." works, as it isn't showing any message, success or error, after performing the operation. It returns to the "General Application Settings" page. "Set Server Defaults" does not work. It gives med the following error from SharePoint:

System.Web.Services.Protocols.SoapException: The report server has encountered a configuration error. If the report server is configured to use SharePoint integrated mode, verify that the server is joined to a SharePoint farm and that the Report Server service account has been granted access to the SharePoint farm. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. If the report server is configured to use SharePoint integrated mode, verify that the server is joined to a SharePoint farm and that the Report Server service account has been granted access to the SharePoint farm.
   at Microsoft.ReportingServices.WebServer.RsSoapBase.Init(String itemPath, Boolean checkAccessToSharePoint)
   at Microsoft.ReportingServices.WebServer.ReportingService2010.Initialize(String itemPath, Boolean checkAccessToSharePoint)
   at Microsoft.ReportingServices.WebServer.ReportingService2010.Initialize(String itemPath)
   at Microsoft.ReportingServices.WebServer.ReportingService2010.GetSystemProperties(Property[] Properties, Property[]& Values)
  
 
The Report Server Logs give me this error:
library!ReportServer_0-1!f28!01/31/2012-09:18:35:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: SharePoint content service is null., Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. If the report server is configured to use SharePoint integrated mode, verify that the server is joined to a SharePoint farm and that the Report Server service account has been granted access to the SharePoint farm.;


The domain account running SSRS has the following:
db_owner for the content database
WSS_Content_Application_Pools for the SharePoint Config Database
User is in the WSS_WPG group in AD - since this is a domain controller no groups are on the server.

What could be the problem?

Answer 1

Dear flowjob,

based on the description you provided, perhaps you have not yet selected the link under the Reporting Services > Reporting Services Integration

this action sets the Report Server Web Service and also sets the permissions for the SSRS Web Service account to have access to the SharePoint system (databases and such).  Until this step is performed the report server is not actually "integrated".

Please perform this step and let us know if that solves your integration issues.

---

Thanks, Eric S. http://www.pcubed.com

Answer 2

Having exactly the same issue. Already tried the sugestion above, but with no success.