Analysis Services Flexibility

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:

1. Open the MSIProperty.ini file located under InstallMedia\AT directory
2. Change VSTF_AS_INSTANCE property to provide information about your SQL Analysis services. You can use any one format mentioned below
   1. For Default Instance: VSTF_AS_INSTANCE= ASMachineName
   2. For Named Instance: VSTF_AS_INSTANCE= ASMachineName/ASInstanceName
   3. For Named Instance with no dependency on SQL Browser or fixed port: VSTF_AS_INSTANCE= ASMachineName:ASPortNumber

Next Run TFS Setup