How to: Connect a Different Application-Tier Server to the Data Tier
You can connect a different application-tier server for Team Foundation to an existing data-tier server by using the TFSAdminUtil command. For example, you might have to restore or reinstall the application-tier server and then connect it to the data-tier server for that deployment.
To perform this procedure, you must be a member of the Administrators group on the application-tier server. For more information about permissions, see Team Foundation Server Permissions.
In addition to these permissions, you might need to address the following requirements on a computer that is running Windows Server 2008 or Windows Vista:
To follow a command-line procedure, you might need to open an elevated Command Prompt by clicking Start, right-clicking Command Prompt, and clicking Run as Administrator.
To follow a procedure that requires Internet Explorer, you might need to start it as an administrator by clicking Start, clicking All Programs, right-clicking Internet Explorer, and then clicking Run as administrator.
To edit web.config files, you might need to start the text editor as an administrator by clicking Start, clicking All Programs, right-clicking the editor, and then clicking Run as administrator.
To access Report Manager, reports, or Web sites for SQL Server Reporting Services, you might need to add these sites to the list of trusted sites in Internet Explorer or start Internet Explorer as an administrator.
For more information, see the Microsoft Web site.
To connect an application-tier server to the data tier
Open a Command Prompt window, and change to the following directory:
Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools
At the command prompt, type the following command but replace MyDataTierServer with the name of the server to which you want to connect:
TFSAdminUtil RenameDT MyDataTierServer