Welcome to MSDN Blogs Sign in | Join | Help

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.

Published Friday, January 26, 2007 11:30 AM by russch

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# Charlie Maitland’s Blog Reporting Services in a Sharepoint farm enviroment «

Saturday, January 27, 2007 2:15 AM by Charlie Maitland’s Blog Reporting Services in a Sharepoint farm enviroment «

PingBack from http://charliem.wordpress.com/2007/01/27/reporting-services-in-a-sharepoint-farm-enviroment/

# re: Reporting Services and MOSS/WSS integration in a farm deployment

Tuesday, January 30, 2007 3:58 PM by Will Riley

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

# re: Reporting Services and MOSS/WSS integration in a farm deployment

Tuesday, January 30, 2007 4:57 PM by russch

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).

# re: Reporting Services and MOSS/WSS integration in a farm deployment

Monday, January 12, 2009 1:28 PM by Osaki

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!!

# re: Reporting Services and MOSS/WSS integration in a farm deployment

Wednesday, November 18, 2009 9:43 AM by Kieran Brennan

Russell,

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

Rgds

Kieran

Leave a Comment

(required) 
required 
(required) 

  
Enter Code Here: Required
 
Page view tracker