This documentation is archived and is not being maintained.

How to: Work with SQL Server Named Instances

You can choose to install Team Foundation Server using the default instance of SQL Server or a named instance of SQL Server. Depending on your business infrastructure and deployment needs, you might prefer to use a named instance. If you want to use a named instance in your Team Foundation Server deployment, you must create that named instance in SQL Server before you install Team Foundation Server. You cannot create a named instance during Team Foundation Server installation. For more information about named instances in SQL Server, see the topic "Instance Name" in the SQL Server 2005 Books Online (

To use a SQL Server named instance in a Team Foundation Server deployment

  • To use a named instance with Team Foundation Server, you must install Team Foundation Server using a named instance. For more information, see the Team Foundation Installation Guide. You can download the latest version of the Team Foundation Installation Guide from the Microsoft Download Center (