I need help figuring out the limitations in a multi-database server environment and MOSS 2007 installation with SSRS. Here is the run down:
- I currently have MOSS 2007 server with backend on SQL 2005, which also acts as the SSRS server. In addition I have another SQL 2005 server where business data resides and against which most of the SSRS reports run.
- Future plan (over which I don't really have a say) is MOSS 2007 with backend on SQL 2008, which will remain to be the SSRS server. The second SQL server with business data will be migrated to SQL 2008 R2.
Questions: does this architecture requires SSRS 2008 add-in or SSRS 2008 R2 add-in (integrated mode)? Will there be an issue of building SSRS 2008 reports that go after SQL 2008 R2 and SQL 2008 data mix?
View Complete Post