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

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
LVL 1
skaleem1Asked:
Who is Participating?
 
rlogConnect With a Mentor Commented:
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
 
rlogCommented:
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
 
skaleem1Author Commented:
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
 
rlogCommented:
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
 
skaleem1Author Commented:
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
All Courses

From novice to tech pro — start learning today.