Orcas Beta2 release of Team Foundation Server will enable support for Analysis server flexibility. Many customers want to install SQL Analysis services on a different machine than SQL Database Services. One primary reason is load balancing. We have enabled this scenario in Orcas. The experience is not very great but the solution works. We will improve the experience going forward in next release.
To setup TFS with Analysis services on different machine than the SQL Database services you need the AS machine name(ASMachineName) and SQL Instance Name(ASInstanceName). If you want to avoid taking dependency on SQL Browser service you require the Port(ASPortNumber) on which AS is running.
Steps to install Orcas with AS Flexibility:
Next Run TFS Setup