How to: Enable the TCP/IP Protocol for a Database Instance

In a dual-server deployment of Team Foundation Server, you must enable the TCP/IP protocol for the Team Foundation database. By enabling this protocol, you gain support for remote connections such as the connection between the application-tier server and the data-tier server for Team Foundation. If the TCP/IP protocol is not enabled for both the database instance and the SQL Server Native Client, the following errors might appear:

  • Error 29108. Team Foundation report server configuration: cannot connect to the Team Foundation data-tier when trying to configure the report server database.

  • TF31001: Team Foundation cannot retrieve the list of team projects from Team Foundation Server. The Team Foundation Server returned the following error: The request failed with HTTP status 503: TF30059: Fatal error while initializing Web service.

Required Permissions

To perform these procedures, you must be a member of the sysadmin security group for SQL Server on the data-tier server for Team Foundation.

To enable the TCP/IP protocol for the database instance

  1. Log on to the data-tier server on which the database instance is defined.

  2. Open the Start menu, point to All Programs, point to Microsoft SQL Server 2005 or Microsoft SQL Server 2008, point to Configuration Tools, and then click SQL Server Configuration Manager.

  3. In the tree pane, click SQL Server 2005 Services or SQL Server 2008 Services.

  4. In the results pane, verify that, under the State column, Running appears next to the name of each service.

    If Stopped appears, right-click the name of the service, and click Start.

  5. In the tree pane, click SQL Server 2005 Network Configuration or SQL Server 2008 Network Configuration to expand it, and then click **Protocols for MSSQLServer/**MyInstanceName.

    If you specified the default instance during installation, the instance name will be MSSQLSERVER.

  6. In the results pane, verify that, under the Status column, Enabled appears next to the name of the TCP/IP protocol.

    If Disabled appears, right-click TCP/IP, and then click Enable.

  7. In the tree pane, click SQL Native Client Configuration to expand it, and then click Client Protocols.

  8. In the results pane, verify that, under the Status column, Enabled appears next to the name of the TCP/IP protocol.

    If Disabled appears, right-click TCP/IP, and then click Enable.

  9. In the tree pane, click SQL Server 2005 Services or SQL Server 2008 Services.

  10. In the results pane, right-click SQL Server (MSSQLServer/MyInstanceName), and then click Restart.

See Also

Tasks

How to: Verify a Connection to the Database Server

Resolving Problems Connecting to the Data-tier Server

Other Resources

Managing SQL Server Services