This documentation is archived and is not being maintained.

Resolving Problems Connecting to the Data-tier Server

Visual Studio 2008

The following table summarizes configuration issues that can cause problems when the application-tier server for Team Foundation tries to connect to the data-tier server. In the table, problems that are more likely to occur appear first. Therefore, you should try the resolutions in the order in which they appear so that you can increase the chance that you can solve the problem quickly.

Problem

Resolution

The TCP/IP protocol is not enabled for a database instance.

Enable the TCP/IP protocol for the Team Foundation database instance. For more information, see How to: Enable the TCP/IP Protocol for a Database Instance.

SQL Server is not running on the data-tier server.

Verify basic connectivity to the data-tier server. Verify that SQL Server is running or restart it. For more information, see How to: Verify a Connection to the Database Server.

A service for SQL Server is not running or is not set to start automatically.

Verify that all services for SQL Server are running. For more information, see How to: Restart a Service and Set it to Start Automatically.

The service account for Team Foundation Server account has no SQL Server login.

If the identity that is assigned to the application pool for Team Foundation Server does not match the SQL Login account for Team Foundation Server on the data-tier server, the Team Foundation Server service cannot log on to the database. This condition occurs most often when a user makes a manual change to the application pool identity, rather than using the TFSAdminUtil ChangeAccount command.

To resolve this issue, run the TFSAdminUtil ChangeAccount command to reset the service account that is assigned to the application pool. For more information, see How to: Change the Service Account or Password for Team Foundation Server.

The name of the data-tier server is not set correctly.

Correct the name assignment for the data-tier server in the Services Web.config file for the application tier. For more information, see How to: Correct the Data-tier Name Configuration.

A Team Foundation database is offline or configured to restrict user access.

Correct the database configuration. For more information, see How to: Correct the Database Configuration.

Stored procedures have been deleted or changed.

Restore the procedures to their original state. For more information, see How to: Restore Missing or Changed Stored Procedures.

The InstanceID of a Team Foundation database is set incorrectly.

Correct the InstanceID. For more information, see How to: Correct the Instance ID for a Database.

Show: