.NET Zone is brought to you in partnership with:

Mohamed Radwan is a Visual Studio ALM MVP and Senior ALM Consultant focusing on providing solutions for the various roles involved in software development and delivery to enable them build better software using Agile Methodologies and Microsoft Visual Studio ALM Tools & Technologies. Mohamed excels in software practices and automation with 12+ years of professional experience spanning the different stages and phases of the Software Development Lifecycle. Mohamed is also an MSc in Agile Methodologies, a frequent speaker at many local and regional technology events, the author of DevMagicFake Mocking Framework, an author of many technical articles & guides, the founder of the TFSEG and co-founder of MEAALM Community. Mohamed also holds number of Microsoft certificates 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 12 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
| 3210 views |
  • submit to reddit

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.)