MOSS Forum

 
Home » Forum » MOSS       Ask a questionRSS Feeds

SQL Report Services Integrated with Multiple Farms

  Asked By: Reuben Lang         Date: Mar 08, 2009      Category: MOSS      Views: 427
 

I just recently configured SQL Reporting Services to work in integrated mode
with SharePoint and I was wondering if I am able to connect a single report
server to multiple farms? In my case I have separate dev, test, and production
systems. I was hoping to be able to run all of those environments off a single
report server with multiple instances. It doesn't seem like that will work
though, since you have to install MOSS/WSS and join the report server to the
farm.

Does that sound right? Am I limited to installing one SharePoint integrated
report server per physical server or can I somehow join the report server to
multiple farms?

Tagged:              

 

1 Answer Found

 
Answer #1       Answered By: Johathan Mcgowan          Answered On: Mar 08, 2009       

Just to answer my own question for the archives, it appears that even though
you can install multiple  instances of SSRS, without some manual hacking you
cannot run  more than one instance of reporting services  in SharePoint
integrated mode per physical server.

 
Didn't find what you were looking for? Find more on SQL Report Services Integrated with Multiple Farms Or get search suggestion and latest updates.


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].