Connecting sql server 2008 to Team Foundation Server (TFS) 2012

Posted on 2013-05-28
Last Modified: 2013-05-30
I have a SQL Sever 2008 R2 running on a Windows 2008 server. I want to connect through the management studio to the Team Foundation Server (TFS) 2012 residing on another server running on Windows 2012 Server. Can I do that? How can I do that? A walkthrough would be highly appreciated,

Question by:skaleem1
  • 3
  • 2

Expert Comment

ID: 39203706
Do you have SQL Server installed on the TFS server? In that case you open SQL Management Studio and press the Connect button -> Database Engine. Enter the name of the SQL 2012 server. You also need to specify what credentials (either your windows account or sql login).

Author Comment

ID: 39204524
No we have SQL Server installed on a different server running on Windows 2008 Server. TFS is located on a different server running on Windows 2012 there anything we can do from SQL Server Mgmt Studio from server1 to connect to TFS running on server2?

Expert Comment

ID: 39205218
Just connect. You should check that firewall is open for traffic in on the SQL Server. Otherwise just Connect -> Database Engine and you should be able to connect.

Author Comment

ID: 39206598
where from SQL Server Mgmt Studio on server 1 can we connect to TFS? I do not see any option in the connect dropdown list. Can you please elaborate?

Accepted Solution

rlog earned 500 total points
ID: 39207280
I don't think you understood my question. Anyway - how to connect to TFS Server from Visual Studio click HERE. You cannot use SQL Management Studio to connect to TFS - but you can connect to the TFS database server and look at your database.

So the answer to your question is NO it's not possible to connect to TFS service on Windows 2012 Server from SQL Server Management Studio.

I hope this answers your question.

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Trying to get a Linked Server to Oracle DB working 21 59
Cannot Change Local DNS 9 44
Help Required 3 96
32bit v 64bit processes and impact on memory 7 40
The article will show you how you can maintain a simple logfile of all Startup and Shutdown events on Windows servers and desktops with PowerShell. The script can be easily adapted into doing more like gracefully silencing/updating your monitoring s…
A procedure for exporting installed hotfix details of remote computers using powershell
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question