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?