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 (5)

  1. Will Riley says:

    Russell,

    Does this mean that we can install the following configuration.

    Backend SQL machine with

    SQL Server 2005 (This can host all the necessary SQL dbs)

    Frontend Web machine

    SSRS 2005, SP2 CTP3

    NET Framework 3.0 (for WSS/MOSS)

    WSS/MOSS Web Front-End

    Or would you recommend keeping the SSRS on the SQL machine ?

    Will

  2. russch says:

    Will, it really is a matter of where you have more free resources. Keep in mind that in the configuration above, you’ll still need a 3rd box (where your Report Library will actually live).

  3. Osaki says:

    Russel, when you have a configuration like you described in your posting (two machines), does it mean that when MOSS box gets upgraded (service packs, etc), you have to upgrade SQL server box too?  If that’s the case, is it just as simple as dowloading the upgrades, installing them, and running the wizard?

    Thanks!!

  4. Russell,

    Are you sure that you have to buy a seperate MOSS license for the SSRS server.

    Rgds

    Kieran