Welcome to MSDN Blogs Sign in | Join | Help
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

Posted: Wednesday, May 30, 2007 11:10 PM by sudhirh

Comments

Sudhir Hasbe said:

Feature List for Orcas New Orcas Setup: Consolidation of multiple Setup SKUs into one single Setup SKU.

# May 30, 2007 11:11 PM

Adam Singer said:

Recently, in part because of such interesting capabilities as Sudhir mentions in his post on Analysis

# June 8, 2007 5:16 PM

Adam Singer said:

As I mentioned in a previous post, our program manager Sudhir is blogging up a storm on all the great

# August 16, 2007 11:15 AM

James Manning's blog said:

Helen : You're late. When you asked me if I was doing anything later, I didn't realize you'd actually

# May 9, 2008 4:24 PM
Anonymous comments are disabled
Page view tracker