Partager via

The Team Foundation database is not configured correctly

  • Article

The information in this article applies to:

  • Visual Studio 2005 Team Foundation Server

  • Visual Studio Team System 2008 Team Foundation Server

  • SQL Server 2005 or Microsoft SQL Server 2008

  • Data-tier server

  • Health check

  • Preinstall check

The Best Practices Analyzer tool for Team Foundation Server checks the status and access restrictions that are assigned to the Team Foundation databases. One of the following errors appears if a database is not configured correctly:

  • Database is configured as SingleUser

  • Database is not Online

If any database is offline or restricts access, you will have problems when you work with Team Foundation, Reports, and SharePoint Products and Technologies Web sites.

To resolve these problems, change the status or property of the affected database.

Required Permissions

To perform this procedure, you must be a member of the Administrators group for the Team Foundation databases.

To change the status or property of a database

  1. Log on to the data-tier server.

  2. Open the Start menu, point to AllPrograms, point to Microsoft SQL Server 2005 or Microsoft SQL Server 2008, and then click SQL Server Management Studio.

    The Connect to Server dialog box opens.

  3. Click Database Engine in Server type, type the name of the server to which you want to connect, and then click Connect.

    Note

    If SQL Server is installed on a cluster, type the name of the cluster and not the computer name. If you have specified a named instance, type the server and instance name in the following format: DatabaseServer\InstanceName.

    SQL Server Management Studio opens.

  4. In Object Explorer, verify that a green arrow appears next to the server name.

  5. Expand Databases.

  6. Verify that none of the following databases appear with (Offline), (Single User), or (Restricted-User) after its name:

    • TfsActivityLogging

    • TfsBuild

    • TfsIntegration

    • TfsVersionControl

    • TfsWarehouse

    • TfsWorkItemTracking

    • TfsWorkItemTrackingAttachments

  7. If a database is Offline, right-click the database, click Tasks, and then click Bring Online.

  8. If a database is set to (Single User) or (Restricted-User) access, perform the following steps:

    1. Right-click the database, and then click Properties.

    2. Click Options.

    3. Under Other options, scroll the window so that the State section appears.

    4. Change the value for Restrict access to MULTI_USER, and click OK.

    5. In the Open Connections dialog box, click Yes.

  9. Close SQL Server Management Studio.

See Also

Other Resources

Issues That Relate to SQL Server and the Team Foundation Database