Next week I plan to install the full SQL2008 R2 BI stack for a customer. We have two machines,
Machine1 with 64GB memory and Machine2 with 32 GB memory. SQL Server 2008 R2 (database engine, SSIS and SSAS) are already installed on Machine 1. We now want to add the following products:
- SharePoint 2010 EE
- Excel Services
- SQL Server Reporting Services Integrated Mode
- PowerPivot for SharePoint
Our plan is to install all these products on Machine2 and keep all databases (SharePoint/SSRS) on Machine1 like described below.
1.SQL Server 2008 R2 SP1 EE (SSIS/SSAS) (already installed)
2.SharePoint 2010 EE (databases on machine1)
4.SQL Server Reporting Services Integrated Mode (databases on machine1)
5.PowerPivot for SharePoint
Is this architecture possible and should we install the products in this order? Are there any things we should be aware of or do you have any tips?