0

Scenario:

  • Windows 2003 with SP2 running as a guest in vmWare.
  • 20gb HDD and 1GB RAM.
  • SQL Express 2005 with Service Pack 3 as Named Instance.
  • SQL 2005 is well configured; known working good; can login, no security problems, etc.
  • installing from the 90 day trial disc: VS2008TeamFoundationServerENU90DayTrialX1429244.iso

The problem occurs at the screen asking:

Type the name of the server that hosts the Team Foundation Server database.

The wording seems to indicate that you'd have already installed a DB!

I soldiered on with gusto, typing in the server's DB instance:

MyServer\SQLExpress

The official error description:

 Microsoft Visual Studio 2008 Team Foundation Server Setup

TF220059: An error occurred while the Setup program was querying the
installation settings for Team Foundation Server.

MSDN Social has a good thread on TF220059, but none of those suggestions didn't work for me. Initially, I didn't have a service pack on my SQL Express. I have since upgraded to SP3 (+ rebooted), but that did not help.

The MSDN Social thread suggests for some people that installing SQL Reporting Services solves the problem. Some reported that it did NOT solve the TF220059 problem.

Question: Any suggestions on what needs to be configured/installed to solve the TF220059 problem?

4 Answers 4

4

SQL Express is not supported for TFS 2008, you must use SQL 2005 or SQL 2008. A full license of TFS comes with a limited use license of SQL Server Standard (basically limited to use only by the TFS application)

SQL Express is supported by TFS 2010, and in fact if you do a basic installation without SQL Express pre-installed it will install it for you.

1
  • +1 - after a few hours attempting to install TFS 2008 with SQL Server Express 2005, this saved the day, thanks!
    – John Rasch
    Jul 1, 2010 at 20:35
1

I've set up TFS a few weeks ago, and had a lot of trouble because nearly everything I tried was not supported.

I endet up not using Windows Server 2008, but 2003R2 instead.
Therefore I did use the older IIS 6 as well.
I did not use SQL Server 2008, but 2005SPx instead.
I did not use a localized version of Windows & SQL Server but the english one instead.
Do not install Sharepoint services myself, instead let TFS setup handle this.

Setup of TFS was a real PITA! I only got it to run properly using the recommended software versions (WS 2003, SQL 2005, all in english).
Whenever I installed it with some other version, either installation failed, or it just did not work, with some very weird error messages. Especially using non-english-Windows Server lead to strange behaviour after installation.

Good Luck!

0

SQL Server Express by default does not expose TCP/IP connectivity. Goto All Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager

For the SQL Server 2005 Network Configuration, look at the Protocols for SQLEXPRESS and enable TCP/IP if it is disabled.

Verify that all ports stated in the TFS installation guide are open at the database server for the app-tier server to make a connection to. You may also want to ensure WMI ports are open for discovery.

UPDATE

After getting back to refer back to the installation guide, I do not think SQL Server Express is a supported edition for TFS. The supported editions are Standard or Enterprise edition. SSAS is needed.

2
  • Great suggestion about WMI. TCPIP is good. Can login remotely. SQL 2005 is well configured; known working good; can login, no security problems, etc.
    – p.campbell
    May 29, 2009 at 14:04
  • Suggestion updated
    – icelava
    May 29, 2009 at 15:29
0

For those wishing to have TFS installation tips or a walkthrough, follow the instructions at Peter Stromquist's blog:

Building a virtualized Team Foundation Server development environment

This has helped clear up a few points on requirements and laying the foundation for installing TFS in a virtual machine. Thanks Peter!

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .