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.