.NET Zone
.NET Zone is brought to you in partnership with:

Mohamed Radwan is a Visual Studio ALM MVP and Senior ALM Consultant @ Marvel ALM with 10+ years of experience in the software industry (Architecture, Design, Development and Management) specializing in Microsoft Technologies and Agile Methodologies with a customer list that spans the Middle East. M.Radwan’s areas of focus are: C# / .NET, ASP.NET, MVC, JQuery, TDD, BDD, Team Build, TFS, Application Architecture, Agile, Process Automation and Improvement, Configuration Management and Automation. M.Radwan is the founder of TFSEG User Group, Co-founder of MEAALM Community , the author of DevMagicFake Mocking Framework and a frequent speaker in different Microsoft events. M.Radwan also holds M.Sc. of Computer Sciences and Information Technology in Agile Methodologies. M.Radwan holds number of Microsoft certifications including MCT, MCPD, MCITP in EPM, MCTS (7), MCSD, MCAD and CIW Mohamed is a DZone MVB and is not an employee of DZone and has posted 10 posts at DZone. You can read more from them at their website. View Full User Profile

Installing TFS 2012 Express with SQL Server 2012 Express on Another Machine

03.15.2013
| 1535 views |
  • submit to reddit

We Recommend These Resources

NOSQL for the Enterprise

Four months ago Buck Hodges from the VS ALM team announced a white paper about how to use tfsconfigure unattend command line  tool to silently configure TFS 2012, this tool gives the ability to configure TFS 2012 from the command line with all predefined configuration.

Today, I am going to explain how to use this great tool to help me install TFS 2012 Express on a machine and use SQL Server 2012 Express that already installed on other machine.

In my scenario I have 2 machines, PC1 (TFS 2012) and PC2 (SQL Server Express).Architecture

After installing TFS 2012 Express on PC1 and SQL Server 2012 Express on PC2 I will not configure TFS and perform the following steps.

* Log In to PC2 with Admin account and make sure that SQL Server option ” Allow remote connections to this server”  is enabled.Allow remote connections to this server is enabled

* Open SQL Server Configuration Manager and make sure that TCP-IP Protocols is enabled for SQL Express.TCP-IP Protocols Enabled for SQL Express

* Log In to PC1 with Admin account that has permission on the SQL machine so it can install DB there, it’s better if you use Domain Controller account.

* Open the command line for Visual Studio as administrator

* Navigate to: C:\Program Files\Microsoft Team Foundation Server 11.0\Tools directory (cd C:\Program Files\Microsoft Team Foundation Server 11.0\Tools

* From the command line run the following command: tfsconfig unattend /configure /type:basic /inputs:SqlInstance=PC2\TFSSQLExpress

PC2: is the second machine.
TFSSQLExpress: is the instance name.

* Make sure that configuration succeed.Configuration Succeed

Published at DZone with permission of Mohamed Radwan, author and DZone MVB. (source)

(Note: Opinions expressed in this article and its replies are the opinions of their respective authors and not those of DZone, Inc.)

"Starting from scratch" is seductive but disease ridden
-Pithy Advice for Programmers