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