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?
Best Answer
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.