Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We are using tfs2008 and it was already set up before I started. I want to find out what the sql server instance name is that is used by tfs 2008.


share|improve this question

Team Foundation Server Administration Console should be able to tell you the Data Tier Server and the SQL Server Instance name.

share|improve this answer
There is no admin console in 2008. – user164231 Mar 12 '13 at 20:53

The instance name is by default TFSINSTANCE. If you're running a single-server deployment where the all of the services are running on the same server then the server name would be \\TFSINSTANCE. You can confirm this by opening the SQL Server Configuration manager on the database server. You should see the SQL Server service which will include the instances name.

see: How to: Stop and Start Services, Application Pools, and Web Sites

You can also use the TFSAdminUtil tool to view the connections that are configured. The /view option is the one that will show you connection settings.

TFSAdminUtil ConfigureConnections /view

see: ConfigureConnections Command

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.