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


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

 

 

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s