TFS Express 2011 Setup - Multiple SQL Instance Detection

Question

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?

Answer 1

Hello CerysDad,

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.

Thanks.

---

Vicky Song [MSFT]
MSDN Community Support | Feedback to us

Answer 2

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

Answer 3

Vicky, please re-read the question.  He is not installing TFS 11 beta, He is installing TFS 11 EXPRESS

Answer 4

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.

Answer 5

Hi CerysDad,

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>

For example:

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,

--Vladimir

Answer 6

I tried this and found out the correct flag is unattend as unnatend throws an invalid command error.

--Nick

Answer 7

You are right. I fixed a typo in my previous post.

Thanks,

--Vladimir