Reporting Services and MOSS/WSS integration in a farm deployment

  • Article

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.