Thanks for your reply. Here are some follow-up questions:
1. I am assuming you had to install the SharePoint on the separate machine where you installed SSRS in SP integrated mode and then join it to the SP farm. Did you have the ReportDB and ReportTempDB on this machine or on the SharePoint DB server? If you installed
the ReportDB and ReportTempDB on the SharePoint DB server, then was it on the same database instance or a separate database instance?
2. Are you aware of any functionality that is missed out when you install SSRS in SP integrated mode? I am pretty sure I want to go with SP integrated mode due to the obvious benefits but I would like to know if SSRS native mode has some features
that will not be available in the integrated mode.
3. Did you have to do any sort of prep work before running the auto installer script for the SSRS install? For example, was there a need to set up certain AD accounts etc. ahead of time? If so, will you be able to share any information regarding that? Any
documentation/script will be great but even general pointers will be very helpful since I haven't done the automated install myself before.
4. Which server (database server or the separate machine for SP integrated SSRS assuming they are on separate machines) you had to kick off the install process? This question is based on the assumption that the installer is run once and it installs all the
components in various server tiers.
5. Also, my initial impression was that SP integrated SSRS install has app server and database server pieces to it. However, after further research I get a sense that it actually has web server and database server pieces but no app server piece, at least
for 2008 R2. By web server pieces I mean SSRS Proxy and Report viewer web part etc. Is this correct? From what you mentioned about SSRS 2012, it looks like that has app server piece since you said that it runs as a SharePoint service in 2012. This is what
I originally thought with respect to 2008 R2 SSRS as well.
6. Have you installed the SP integrated SSRS on a single machine or in a cluster?
7. As far as Analysis Services is concerned, since we are just starting to set that up, I am looking to install both "regular" and "SP integrated" Analysis Services. It sounds like I should set that up on a separate machine as far as "regular" Analysis Services
is concerned. However, do you have any thoughts/ideas on which machine should the SP integrated Analysis Services be installed? Do you have Analysis Services installed in your environment? If so, which one (regular or integrated)?
Your suggestion about using 2012 version is very timely. I'll look into it and try to figure out the licensing and other aspects before firming up that path, not to mention understanding the new features and capabilities and how it maps to the existing system
architecture. However, that'll take some time so I'll continue to explore the system architecture using 2008 R2 components meanwhile.
I appreciate your time and feedback and look forward to your response.
Thanks in advance!