Reporting Services and MOSS/WSS integration in a farm deployment
Now that SQL 2005 SP2 CTP3 supports installing SSRS on a different box than the MOSS/WSS machine, people have been bumping into problems getting everything working properly. After installing / configuring, common error messages you may see are:
"Failed to find the XML file at location '12\Template\Features\DataConnectionLibrary\Feature.xml'()"
and/or...
“Could not load file or assembly ‘Microsoft.Office.Server’ or one of its dependencies.
Here are the basic requirements you need to take care of in order to get everything working:
Reporting Box
· SSRS 2005, SP2 CTP3
· .NET Framework 3.0 (for WSS/MOSS)
· WSS/MOSS Web Front-End (will lay down assemblies SSRS Integration needs)
WSS/MOSS Box
· WSS/MOSS (and all pre-requisites for installing same)
· SSRS integration add-in (SharePointRS.msi)
A key point not yet in the readme and/or documents is that you must install the same version of MOSS and/or WSS on both machines. You may not mix SKUs, or integration will break on the reporting box with the first error message mentioned above. This also means you’ll be purchasing a MOSS/WSS license for the SSRS machine.
Comments
- Anonymous
January 26, 2007
PingBack from http://charliem.wordpress.com/2007/01/27/reporting-services-in-a-sharepoint-farm-enviroment/ - Anonymous
January 30, 2007
Russell,Does this mean that we can install the following configuration.Backend SQL machine withSQL Server 2005 (This can host all the necessary SQL dbs)Frontend Web machineSSRS 2005, SP2 CTP3NET Framework 3.0 (for WSS/MOSS)WSS/MOSS Web Front-EndOr would you recommend keeping the SSRS on the SQL machine ?Will - Anonymous
January 30, 2007
The comment has been removed - Anonymous
January 12, 2009
The comment has been removed - Anonymous
November 18, 2009
Russell, Are you sure that you have to buy a seperate MOSS license for the SSRS server. Rgds Kieran