Home Library Learn Downloads Support Community
Sign in | United States - English | |
2 out of 3 rated this helpful - Rate this topic

How to: Rename a Data-Tier Server

Visual Studio 2005

You can rename your Team Foundation data-tier server. To do this, you must rename the computer itself and perform several other steps to reconfigure Team Foundation Server, Reporting Services, and Windows SharePoint Services.

NoteNote

If you have configured Team Foundation Server Proxy for a single-server Team Foundation Server deployment, you must modify the proxy.config file by using the new name of the Team Foundation application-tier server as part of renaming your Team Foundation data-tier server. For more information, see Team Foundation Server Proxy and Source Control.

NoteNote

This procedure works for both single-server Team Foundation Server configurations and for renaming the Team Foundation data-tier server in a dual-server Team Foundation Server deployment.

Required Permissions

To perform this procedure, you must be a member of the Administrators group on the Team Foundation data-tier server. For more information about permissions, see Team Foundation Server Permissions.

To stop the services used by Team Foundation Server

  1. On the Team Foundation application-tier server, click Start, click All Programs, click Microsoft SQL Server 2005, click Configuration Tools, and then click Reporting Services Configuration.

    The Reporting Services Configuration Manager window opens, and the Report Server Installation Instance Selection dialog box opens.

  2. Make sure that the information in Machine Name and Instance Name are correct and then click Connect to connect to the server. Close the Report Server Installation Instance dialog box.

  3. Select Server Status and then click Stop.

  4. Click Exit to close the Reporting Services Configuration window.

  5. On the Team Foundation application-tier server, click Start, click Administrative Tools, and then click Internet Information Services (IIS) Manager.

    The Internet Information Services (IIS) Manager window opens.

  6. Expand the Team Foundation application-tier computer node, and then expand the Web Sites node.

  7. Select the Default Web Site, and then click Stop.

  8. Expand the Team Foundation application-tier computer node, and then expand the Application Pools node.

  9. Select the ReportServer application pool, and then click Stop.

  10. Select the TFS AppPool application pool, and then click Stop.

  11. Click Exit to close the Internet Information Services (IIS) Manager window.

  12. On the File menu, click Exit to close the Internet Information Services (IIS) Manager window.

  13. On the Team Foundation application-tier server, click Start, click Administrative Tools, and then click Services.

    The Services window opens.

  14. Select the SharePoint Timer Service service, and then click Stop.

  15. Select the TfsServerScheduler service, and then click Stop.

  16. On the File menu, click Exit to close the Services Manager window.

To rename the computer

  1. On the Team Foundation data-tier server, click Start, right-click My Computer, and then click Properties.

    The System Properties window opens.

  2. In the Computer Name tab, click Change.

    The Computer Name Changes window opens.

  3. In the Computer Name box, type the new computer name, and then click OK.

  4. Click Exit to close the System Properties window.

To update Team Foundation Server to use the new data-tier server name

  1. On the Team Foundation application-tier server, click Start, click All Programs, click Accessories, and then click Command Prompt.

    The Command Prompt window opens.

  2. Open a Command Prompt window and change directories to the drive:\%ProgramFiles%\Microsoft Visual Studio 2005 Team Foundation Server\Tools directory.

  3. At the command prompt, run the TFSAdminUtil tool with the RenameDT option to connect to the data tier, as shown in the following example:

    TFSAdminUtil RenameDT newservername

  4. Close the Command Prompt window.

To update Team Foundation Server to use the new application-tier server name, if it is configured as a single server

  1. On the Team Foundation application-tier server, click Start, click All Programs, click Accessories, and then click Command Prompt.

    The Command Prompt window opens.

  2. Open a Command Prompt window and change directories to the drive:\%ProgramFiles%\Microsoft Visual Studio 2005 Team Foundation Server\Web Services directory.

  3. Open the web.config file in any plain-text editor, such as Notepad.

  4. Replace the old Team Foundation data-tier server name with the new Team Foundation data-tier server name in the add key elements that define TfsNameURL and TFS Name, as shown in the following example.

    Copy 
    <!-- TFS name and Url information -->
<add key="TFSNameUrl" value="http://newDataTierServerName:8080" />
<add key="TFS Name" value="newDataTierServerName "/>

  5. On the File menu, click Save.

  6. On the File menu, click Exit to close the plain-text editor.

  7. Open a Command Prompt window and change directories to the drive:\%ProgramFiles%\Microsoft Visual Studio 2005 Team Foundation Server\TfsServerScheduler directory.

  8. Open the TfsServerScheduler.exe.config in any plain-text editor, such as Notepad.

  9. Replace the old Team Foundation data-tier server name with the new Team Foundation data-tier server name in the add key element that defines TfsNameUrl. For example:

    Copy 
    <add key="TfsDomainUrl" value="http://newDataTierServerName:8080" />
    NoteNote

    The key name may be BisDomainURL instead of TfsNameURL. If so, change the key name to TfsNameURL.

  10. On the File menu, click Save.

  11. On the File menu, click Exit to close the plain-text editor.

  12. Open a Command Prompt window and change directories to the drive:\%ProgramFiles%\Microsoft Visual Studio 2005 Team Foundation Server\CoverAn directory.

  13. Open the CoverAn.exe.config in any plain-text editor, such as Notepad.

  14. Replace the old Team Foundation data-tier server name with the new Team Foundation data-tier server name in the add key element that defines TfsNameUrl. For example:

    Copy 
    <add key="TfsNameUrl" value="http://newDataTierServerName:8080" />

  15. On the File menu, click Save.

  16. On the File menu, click Exit to close the plain-text editor.

  17. Open a Command Prompt window and change directories to the drive:\%ProgramFiles%\Microsoft Visual Studio 2005 Team Foundation Server\Tools directory.

  18. At the command line, run the TFSAdminUtil tool with the ActivateAT option to activate the Team Foundation application-tier server. For example:

    TFSAdminUtil ActivateAT

    NoteNote

    There will be a warning that indicates that the Team Foundation data-tier server is bound to the old Team Foundation application-tier server name. When you are prompted whether to continue, press Y to continue.

  19. Close the Command Prompt window.

In a single-server configuration, client users must connect to the newly renamed Team Foundation application-tier server if they were previously using the Team Foundation application-tier server under its old name. If client users were connected to the Team Foundation application-tier server when the renaming procedure was performed, they may have to update their Team Foundation Server caches and run the devenv /resetuserdata command, or wait two hours before reconnecting.

To start and configure Reporting Services

  1. On the Team Foundation application-tier server, click Start, click Administrative Tools, and then click Internet Information Services (IIS) Manager.

    The Reporting Services Configuration Manager window opens, and the Report Server Installation Instance Selection dialog box opens.

  2. Make sure that the information in Machine Name and Instance Name are correct, and then click Connect to connect to the server. Close the Report Server Installation Instance dialog box.

  3. Expand the Team Foundation application-tier computer node, and then expand the Application Pools node.

  4. Select the ReportServer application pool, and then click Start.

  5. Expand the Web Sites node, select Default Web Site, and then click Start.

  6. On the File menu, click Exit to close the Internet Information Services (IIS) Manager window.

  7. Click Start, click All Programs, click Microsoft SQL Server 2005, click Configuration Tools, and then click Reporting Services Configuration.

    The Reporting Services Configuration Manager window opens.

  8. Select Database Setup, in the Server name, enter the new data-tier server name, and then click Apply.

  9. Select Server Status and then click Start.

  10. If Team Foundation Server is configured as a single server, select Windows Service Identity, change the Built-in Account selection to Local System, set the Built-in Account back to Local Service, and then click Apply.

  11. Click Exit to close the Reporting Services Configuration window.

  12. Open a browser and browse to http://applicationTierServerName/reports in the address bar.

  13. On the SQL Server Reporting Services home page, click TfsOlapReportDS.

    1. Change the Connection String to use the new Team Foundation data-tier server name, as shown in the following example.

      Data source= DataTierServerName ;initial catalog=TfsWarehouse

    2. Select Credential stored securely in the report server.

    3. Enter the account name (including domain if applicable) and password for services account specified for the Reporting Services service account (referred to as TFSReports).

      NoteNote

      If you do not know which service account you need, use SQL Server Management Studio to check which account belongs to the TfsWarehouseDataReader role in the TfsWarehouse database.

    4. Select Use as windows credentials when connecting to the data source, and then click Apply.

    5. Click Home in the upper-left corner to return to the SQL Server Reporting Services home page.

  14. On the SQL Server Reporting Services home page, click TfsReportDS.

    1. Change the Connection String to use the new Team Foundation data-tier server name, as shown in the following example.

      Data source= DataTierServerName;initial catalog=TfsWarehouse

    2. Select Credential stored securely in the report server.

    3. Enter the account name (including domain if applicable) and password for the Reporting Services service account (referred to as TFSReports).

    4. Select Use as windows credentials when connecting to the data source, and then click Apply.

  15. On the File menu, click Close to close the browser.

To rebuild the data warehouse OLAP cube

  1. On the Team Foundation application-tier server, click Start, click All Programs, click Accessories, and then click Command Prompt.

    The Command Prompt window opens.

  2. Open a Command Prompt window and change directories to the drive:\%ProgramFiles%\Microsoft Visual Studio 2005 Team Foundation Server\Tools directory.

  3. Rebuild the warehouse Analysis Services database by typing the following command:

    setupwarehouse -o -s DataTierServerName -d TfsWarehouse -c warehouseschema.xml -ra TFSReportAccount -a TFSServiceAccount

  4. Close the Command Prompt window.

  5. On the Team Foundation data-tier server, click Start, click All Programs, click Microsoft SQL Server, and then click SQL Server Management Studio.

  6. Select Analysis Server for the Server type, select the data-tier server name, and then click Connect.

  7. Expand the Databases node to see the list of Analysis Services databases installed on the Team Foundation data-tier server.

  8. Right-click the TFSWarehouse database and then click Process.

  9. In the Process Database dialog box, click OK to process the warehouse.

  10. Click Close to close the Process Progress dialog box.

  11. On the File menu, click Exit to close SQL Server Management Studio.

To configure and start Windows SharePoint Services

  1. On the Team Foundation application-tier server, click Start, click Administrative Tools, and then click SharePoint Central Administration.

    The SharePoint Central Administration window opens.

  2. In the Server Configuration section, select Set configuration database server, type the new Team Foundation data-tier server name in the Database server field, select the Connect to existing configuration database, and then click OK.

  3. In the Server Configuration section, select Set default content database server, type the new Team Foundation data-tier server name, and then click OK.

  4. On the File menu, click Close to close the SharePoint Central Administration window.

  5. Click Start, click Administrative Tools, and then click Services.

    The Services window opens.

  6. Select SharePoint Timer Service, and then click Start.

  7. On the File menu, click Exit to close the Services window.

If the old Team Foundation data-tier server name is still recognized in Active Directory, Windows SharePoint Services might not accept the new server name. If that occurs, wait for the old server name to be purged, and then repeat this procedure.

To start the remaining services used by Team Foundation Server

  1. On the Team Foundation application-tier server, click Start, click Administrative Tools, and then click Services.

    The Services window opens.

  2. Click the TfsServerScheduler service, and then click Start.

  3. On the File menu, click Exit to close the Services window.

  4. On the Team Foundation application-tier server, click Start, click Administrative Tools, and then click Internet Information Services (IIS) Manager.

    The Internet Information Services (IIS) Manager window opens.

  5. Expand the Team Foundation application-tier server node, and then expand the Application Pools node.

  6. Select the TFS AppPool application pool, and then click Start.

  7. On the File menu, click Exit to close the Internet Information Services (IIS) Manager window.

See Also

Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ
What about rebooting?
After changing the computer name, it asked me to reboot. Since that step was not listed in the doc, I said no, but then the RenameDT step did not work because the new name was not a valid computer. So I rebooted. Then I went back to the Services pane and stopped Sharepoint TimerService and TFSServerScheduler again before proceeding.

I also had to re-import the Reporting Services encryption keys after restarting that service - fortunately I had a backup. Be sure to back them up before starting this procedure, if you haven't already.

With that done, Sharepoint still didn't work for me; the event log said it was still trying to connect to the old machine. Even though the above steps have you change the default content and config databases, the Default Web Site was still looking for its database on the old machine. I went into its config through Sharepoint Central Administration, deleted its content database, and then added a new one. I had to give it the name of the existing db (STS_Content_TFS for me), because the default creates a new db instead of connecting to the old one.

Now it finally works. I wouldn't call it a breeze, but if they fix the 4 or 5 errors in the doc, it could pass for a minor gale.

Whoops, spoke too soon. Sharepoint was still trying to grab reports from the old server. Looking at Buck Hodges' blog, http://blogs.msdn.com/buckh/archive/2007/03/31/configuring-team-foundation-server-to-use-fully-qualified-domain-names.aspx, I found the registry key to change that got that bit working.
History
Errors in documentation?

When following the instructions, I came across two things where I had to do different things than stated in this documentation:

Section "to start and configure reporting services"

Step 1 states that you have to select the reporting server instance. This is wrong, because you will be in IIS Manager console, which has no means to select a reporting server.

The second sentence of Step 1 and Step2 are erroneous.

Section "To Rebuild the data warehouse OLAP cube"

Step 3 lists the parameters for rebuilding the data warehouse. When entering exact the given parameter list, you wull get an error "-mturl parameter is missing"; you have to add -mturl http://servername:8080.

This leads to another change: you will have to start the Tfs AppPool application pool before rebuilding the data warehouse, else the connection will not be possible. The instructions for that are given later in the document (Steps 4-7 of "To start the remaining services...").

With my process, I was not able to rebuild the warehouse because of an error telling me that some colum information could not be retrieved. Maybe this was due to missing credential information, but for me the alternative worked:

before renaming the server (name it Step 0 of the whole procedure):

  • Open Sql Server Management Studio
  • select the TFS data tier server
  • connect to analysis services
  • select the TfsWarehouse Database
  • in the context menu, select "Script Database"->" as Create to"->"New Query window"
  • find all occurrences of the old server name and replace them with the new server name
  • save the script with an arbitrary filename

After renaming the server, just before the step "To rebuild the data warehouse olap cube"

  • Stop the Sql Server Analysis Services Windows Service
  • delete the directory and the .xml file that start with "Tfswarehouse" in the "C.\Program Files\Microsoft SQl Server\MSSQL.2\OLAP\Data" directory
  • Start the Sql Server Analysis Services Windows Service
  • Open Sql Server Management Studio
  • select the (renamed) TFS data tier server
  • connect to analysis services
  • select the Databases folder
  • open the previously saved script
  • execute the script

For me, that did the work.

The rest of the documentation was totally correct, and the whole process (excluding the warehouse rebuild step) worked as a breeze.


History