SQL Server 2008 R2, SharePoint 2010, Excel Services, Reporting Services Integrated Mode and PowerPivot for SharePoint installation on 2 physical machines

Question

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.

Machine1 (SQL)

1.      SQL Server 2008 R2 SP1 EE (SSIS/SSAS) (already installed)

Machine2 (SharePoint)

2.      SharePoint 2010 EE (databases on machine1)

3.      Excel Services

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?

Thanks in advance.

-Jorg

---

Answer 1

Yes, this is a supported configuration, howbeit with no redundancy.

A good place to start is here:

http://technet.microsoft.com/en-us/library/cc789337.aspx