Solved

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

Posted on 2013-05-28
5
963 Views
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,

Thanks
0
Comment
Question by:skaleem1
  • 3
  • 2
5 Comments
 
LVL 4

Expert Comment

by:rlog
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).
0
 
LVL 1

Author Comment

by:skaleem1
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 Server...is there anything we can do from SQL Server Mgmt Studio from server1 to connect to TFS running on server2?
0
 
LVL 4

Expert Comment

by:rlog
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.
0
 
LVL 1

Author Comment

by:skaleem1
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?
0
 
LVL 4

Accepted Solution

by:
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.
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…

705 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now