How to: Correct the Database Configuration

  • Article

If you have problems accessing the Web sites for Team Foundation Server, Reporting, or SharePoint Products and Technologies, you should verify whether a database for Team Foundation is offline or configured to restrict access.

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 configuration of a Team Foundation 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.

  3. In the Connect to Server dialog box, 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, the server name is the name of the cluster and not the computer name.

    Microsoft 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

Tasks

Resolving Problems Connecting to the Data-tier Server

Other Resources

Correcting Connection and Configuration Procedures