15 Maret 2012 11:59
When i go through the TFS Express 2011 configuration process, it detects an existing sql express instance which is configured to work with a third party application and attempts to connect to it.
I want TFS to use its own instance (either by me installing another instance manually or by it downloading SQL 2012 Express itself, either is fine) but i cant find anywhere to specify this. It simply wants to connect to the existing instance. If i install a second instance of SQL, it lists both as detected in the TFS log file but attempts to connect to the first one only.
Is there anyway to specify which SQL instance TFS should set itself up in or specify that it should download and install SQL itself?
17 Maret 2012 4:43Moderator
What is the Configuration Wizard you are using to configure your TFS11 Beta server? And if you are using the Basic Configuration Wizard, in the SQL Instance Page you will have the option to choose whether to use an existing SQL Server instance or to install SQL Server Express. If you choose the frist option, you can specify one SQL Server instance in the next page.
Vicky Song [MSFT]
MSDN Community Support | Feedback to us
22 Maret 2012 14:50When i looked at this, it only gave me the option to select the first instance it found, not to chose between the two? It's detecting both in th log file but not allowing me to chose between them.
22 Maret 2012 21:04
Vicky, please re-read the question. He is not installing TFS 11 beta, He is installing TFS 11 EXPRESS
27 Maret 2012 11:32
Did you get an an answer to this CerysDad? Having the same problem myself. I've created a new express instance called TFSEXPRESS but the install always trys to connect to SQLEXPRESS which it can't use as its an old version.
Any help would be appreciated, cheers.
31 Maret 2012 3:40Moderator
You can execute the following command from the elevated command prompt to configure TFS:
Change to c:\Program Files\Microsoft Team Foundation Server Dev11\Tools
TfsConfig unattend /configure /type:basic /inputs:SqlInstance=<machine-name>\<Your-SqlInstance>
TfsConfig unattend /configure /type:basic /inputs:SqlInstance=mytfsbox\TfsExpress
You will need to install a SQL Express instance manually in this case.
I hope this will help,
10 April 2012 11:09
I tried this and found out the correct flag is unattend as unnatend throws an invalid command error.
28 April 2012 5:33Moderator
You are right. I fixed a typo in my previous post.