Share via

SQL Server is not listening for remote connections using TCP/IP

  • 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 and SQL Server 2008

  • Dual-server deployment

  • Data-tier server

  • Health check

  • Preinstall check

The Best Practices Analyzer tool for Team Foundation Server checks the configuration of the servers that you specified in the scan. An error appears if TCP/IP is disabled for the database instance for Team Foundation. You must resolve this error condition before you install Team Foundation Server or to restore normal operations.

To resolve this issue, you must enable the TCP/IP protocol for the database instance for Team Foundation. You can use the SQL Server Configuration Manager tool to modify the setting.

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 where the database instance for Team Foundation 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.

For more information about prerequisite software and installation procedures, see the Team Foundation installation guide:

See Also

Other Resources

Issues That Relate to SQL Server and the Team Foundation Database