I get this error via the log files on the actual reporting server when i
click on the server defaults link via reporting services in Central
management:
"SharePoint content service is null". Report Server may not have joined the
SharePoint farm, or Report Server service account may not have been granted
access to farm
I also get these errors on the actual screen, depending on whether i have
clicked on the link on the sharepoint server or from the reporting server:
While on the sharepoint 2007 server.. from central management i get:
An unexpected error occurred while connecting to the report server. Verify
that the report server is available and configured for SharePoint integrated
mode. --> Server was unable to process request. ---> Client found response
content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server Reporting
Services 9.00.3068.00" />
<meta name="HTTP Status" content="500" />
While if i try to browse to :
http://server/reportserver$Portal
OR
An unexpected error occurred while connecting to the report server. Verify
that the report server is available and configured for SharePoint integrated
mode.
I'm running the sharepoint server on a seperate 2008 server box, while sql
2005 is on its own box, with sharepoint 2007 installed there too (for object
use only.. web front end etc).. i installed the RS add-in on the real
sharepoint box (2008 server)..
I'm fairly certain i have tried the things mentioned in this thread:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1282744&SiteID=1
At this point i have the reporting web service and both application pools
using a domain admin identity (sqlservice account name).
I've rolled through and done the setspn steps, on both the reporting server
and the sharepoint 2007 server.
I've also tried adding the sqlservice account as a site collection
administrator. (i couldnt see how to add the local account network service
as a site collection admin)..
I have things set to run as trusted account in the central management
setting.
I really dont know what else to try here..I'm also not sure if its an
interaction issue with 2008 server or not..
I also have the reporting services add-in installed on only the
original/main sharepoint 2007 server, which i had trouble getting installed
at first.. it would roll back at the end, the log would reveal an error about
sharepoint not being installed or configured but i was able to install by
doing the files only install trick, followed by the command line install and
parameter (-I)..
I've also set the reporting server virtual directory to integrated mode if
it wasnt already (i didnt do this option on the central admin web site
though, i was afraid to hose our intranet).
I have multiple sql 2005 instances on this box, so there are multiple
report servers listed in IIS.
If i try to browse to the report server web page i get:
The report server has encountered a configuration error. See the report
server log files for more information. (rsServerConfigurationError)
**Also.. under central management site settings..site collection features..
Report server integration feature is enabled already..
Any thoughts out there?
Cheers