How to: Correct the Instance ID for a Database

  • Article

The TFSBuild, TFSIntegration, and TFSVersionControl databases must have the same instance IDS. If they do not match, the following error might appear:

  • Failed to retrieve data from the server. Please verify the network connection and try again.

Required Permissions

To perform these procedures, you must be a member of the Administrators group for the Team Foundation databases. For more information, see Team Foundation Server Permissions.

To correct the instance ID for a database

  1. Log on to the data-tier server for Team Foundation.

  2. Click Start, point to Administrative Tools, and click Event Viewer.

    Event Viewer opens.

  3. Click Application, and look for an error that contains the following information:

    "Found instance xxxx-xxx-xxxxxxxxxx expected instance xxxx-xxx-xxxxxxxxxy"

  4. Click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.

  5. In the Connect to Server dialog box, verify that the Server type is set to Database Engine and the Server name points to the data-tier server and database instance for Team Foundation.

  6. Click Connect.  

    Note

    If SQL Server is installed on a cluster, the server name is the name of the cluster and not the computer name.

    Microsoft SQL Server Management Studio opens.

  7. In Object Explorer, expand Databases, and then verify that the TFSBuild, TFSIntegration, and TFSVersionControl databases appear in the list.

  8. If one or more of the databases do not appear in the list, you must repair the databases for Team Foundation.

    For more information, see "How to: Repair Team Foundation Server" in the Team Foundation Server Installation Guide. You can obtain the most recent version of this guide from the Microsoft Download Center.

  9. Right-click TFSBuild, and click Properties.

    The Database Properties - TfsBuild opens.

  10. Click Extended Properties, and note the value that is assigned to TFS_INSTANCE. If the value does not match the value that is listed in step 3, change it to the appropriate value.

  11. Repeat steps 9 and 10 for TFSIntegration and TFSVersionControl databases.

See Also

Tasks

Resolving Problems Connecting to the Data-tier Server

Other Resources

Correcting Connection and Configuration Procedures