On the application-tier server, open Internet Explorer, type the following string in the Address bar, and press ENTER:

http://localhost:8080/Warehouse/v1.0/warehousecontroller.asmx

The ControllerService page opens.

Click GetWarehouseStatus.

On the GetWarehouseStatus page, click Invoke.

If the warehouse service is idle, it returns an XML document that indicates the status of the service.

<WarehouseStatus …>Idle</WarehouseStatus>

Caution:
If the service is busy, wait until it becomes idle before you continue with the next steps.

On the server that hosts the relational databases for Team Foundation, click Start, point to All Programs, point to Microsoft SQL Server, and then click SQL Server Management Studio.

The Connect to Server dialog box opens.

In Server type, click Database Engine.

In Server name, click the name of the existing data-tier server and database instance, and then click Connect.

In Object Explorer, expand the node for the existing data-tier server, and then expand the Security folder.

Right-click the Logins folder, and then click New Login.

On the General page, click Search.

The Select User or Group dialog box opens.

Type the domain account for the server that will host Analysis Services. Click Check Names, verify that the account name resolves to a known account, and click OK.

Note:
The form of the domain account for a computer is Domain\ComputerName$. For example, the domain account for a computer that is named MyServer in a domain that is named MyDomain would be MyDomain\MyServer$.

Click the User Mapping page, and select the TFSWarehouse check box.

Under Database role membership for: TFSWarehouse, select the TFSWarehouseDataReader and public check boxes, and then click OK.

On the server that hosts the relational databases for Team Foundation, in SQL Server Management Studio, open Object Browser, expand Databases, expand TFSIntegration, expand Tables, click dbo.tbl_database, and then click New Query.

In the query window, create the following query except substitute the name of the new server.

INSERT INTO [TfsIntegration].[dbo].[tbl_database]
([fk_registry_entry_id], [name], [dbname], [servername], [connection], [excludebackup])
SELECT [fk_registry_entry_id]
      ,'TfsWarehouse'
      ,[dbname]
      ,'New Data-tier Server for Analysis Services'
      ,[connection]
      ,[excludebackup]
  FROM [TfsIntegration].[dbo].[tbl_database]
  WHERE [name]= 'TfsWarehouse'

On the Query menu, click Execute.

On the application-tier server, open a Command Prompt window, and change directories to Drive:Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools.

Type the following command, and wait for it to finish:

SetupWarehouse.exe -rebuild -sDataTierServerName-d TFSWarehouse -c warehouseschema.xml -ra TFSReportServiceAccount -a TFSServiceAccount -mturl http://ApplicationTierServerName:Port -edt TfsBuild

You must replace the arguments as the following table describes:

Note:
The -d option must specify TfsWarehouse, the name of the data warehouse database for Team System.

On the server that hosts Reporting Services, open an Internet browser, type the following string in the Address bar, and press ENTER:

http://localhost/Reports

If you have deployed a named instance on the primary data-tier server, type the following string instead:

http://localhost/Reports_TFSInstance

The Report Manager page opens.

Click TfsOlapReportsDS.

In Connection String, specify the new server that hosts SQL Server Analysis Services as the data source.

For example, type the following string:

Data source=AnalysisServicesServerName\InstanceName;initial catalog=TfsWarehouse

Retype the password for the stored credentials, and then click Apply.