Bagikan melalui

Reporting Services and MOSS/WSS integration in a farm deployment

  • Artikel

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