Single Reporting Server connecting to multiple farms? RRS feed

  • Question

  • Can I connect a single SSRS 2008 server to two different SharePoint Farms?  I have a single SSRS 2008 box with two different Reporting instances.  I'd like to have one instance connect to a WSS 3.0 farm, and another connect to a MOSS 2007 farm.  We're migrating from WSS to MOSS, but it may take some time for us to purchase the appropriate licenses, and we want to have reporting in both farms. 

    It seems like the Sharepoint Configuration Wizard on the reporting server will only allow it to connect to a single farm?


    -- Chad
    Monday, July 6, 2009 4:06 PM


  • I don't think that's possible.  WSS & MOSS only support a given machine/OS being in a single farm.  So when you have 2 SSRS instnaces on the same box, they will both be part of the same farm.  You'd need to install two different computers, or use a virtualization technology to have two different virtual OSes running on the single hardward box.

    Hope that helps,
    This posting is provided "AS IS" with no warranties, and confers no rights.
    Tuesday, July 7, 2009 6:52 PM