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

Question

Hello,

I'm installing the Team Foundation Server 2008 on a clean Windows Server 2008 Standard RC1 installation with SQL Server 2005 with SP2. My firewall has been shut down, and I am installing this on a workgroup (not a domain).

I've verified that SQL Server was installed correctly, and I can work with its databases with no problems...

Now that I'm trying to install Team Foundation Server, right when the setup program asks me for the server that hosts the Team Foundation Server database, I type in the computer name, and I get the following error:

TF220059: An error occurred while the Setup program was querying the installation settings for Team Foundation Server. For more information about this error, see the installation logs. For more information about the installation logs, see "Troubleshooting Installation for Team Foundation" in the Team Foundation Installation Guide.

Unfortunately, that guide is quite outdated for Windows Server 2008, as it mentions "Documents and Settings"... I found only one relevant file on %TEMP%, which I reproduce below.

[02:36:10.357] [0x00000001] TFS_SERVICE_ACCOUNT is not specified.
[02:36:10.357] [0x00000001] TFS_REPORTING_ACCOUNT is not specified.
[02:36:10.361] [0x00000001] [LCID]='1033'
[02:36:10.361] [0x00000001] [Server]='Miyuki'
[02:36:10.361] [0x00000001] [CurrentDir]='C:\Users\Administrator\AppData\Local\SIT33484.tmp'
[02:36:10.361] [0x00000001] [INSTANCE_PREFIX]=''
[02:36:10.361] [0x00000001] [SERVICE_ROLE]='TFSEXECROLE'
[02:36:10.361] [0x00000001] [VSTF_AS_INSTANCE]='Miyuki'
[02:36:10.361] [0x00000001] [VSTF_AS_DATABASE]='TfsWarehouse'
[02:36:10.369] [0x00000001] CheckINTLcid.sql
[02:36:10.482] [0x00000001] CheckINT.sql
[02:36:10.486] [0x00000001] TfsIntegration DataStoreNotFound
[02:36:10.486] [0x00000001] CheckVC.sql
[02:36:10.490] [0x00000001] TfsVersionControl DataStoreNotFound
[02:36:10.490] [0x00000001] CheckWIT.sql
[02:36:10.497] [0x00000001] TfsWorkItemTracking DataStoreNotFound
[02:36:10.497] [0x00000001] CheckTB.sql
[02:36:10.501] [0x00000001] TfsBuild DataStoreNotFound
[02:36:10.501] [0x00000001] CheckWH.sql
[02:36:10.509] [0x00000001] TfsWarehouse DataStoreNotFound

If the error is that these data stores don't exist, I think that the setup program should be able to create them. But even if I do create them, the error persists, with a different message which says that the tables don't exist.

I haven't found any page on the internet with this precise error, so I turn to the experts here. Is there anything I'm doing wrong? I can't see anything out of the ordinary with my installation.

Best regards,

Oscar Rodriguez

Answer 1

Oscar,

 

I am having a similar problem as well. Can you please post the soultion when you get to know the answer.

 

Ta

Answer 2

 

Well, I got the same TF220059 error on TFS 2008 Trial after trying a number of things and wasting a few hours I was able to find the logs and saw the error: *** ERROR: Failed to find any SQLRS instances through WMI!

 

Once I installed Reporting Services on SQL 2005 the error went away.  Note: Reporting Services is not a requirement in TFS 2005.

 

Good times. 

Answer 3

 

I installed reporting services but still no go..

Getting the following when entering in the instance name of my sql server install.

---------------------------
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. For more information about this error, see the installation logs. For more information about the installation logs, see "Troubleshooting Installation for Team Foundation" in the Team Foundation Installation Guide.
---------------------------
OK  
---------------------------

Answer 4

 

I hit the same error. I was able to resolve the error by installing a named instance SQL Server 2005 on the same box I was attempting to install TFS on. Once the instance was installed, I was still unable to connect to the instance. Only when I used LOCALHOST\TFS was I able to connect.

 

Let me know if this doesn't work and I will try to repro with the conditions that you describe.

 

 - Anthony Mallgren

 

Disruptive Technology LLC

Creating Waves of Innovation ©

Answer 5

As an additional note, I could only connect with localhost due to remote connections being disabled. Once I ran the surface configuration tool and enabled TCP/IP, everything functioned as expected.

 

Anthony Mallgren

 

Disruptive Technology LLC

Creating Waves of Innocation ©

Answer 6

Urgent...........

 

How to install Reporting Services on SQL server 2005..

Can u pls send me the link for downloading the Sql Server 2005 with Reporting Services..

After Installing will it remove this error.

 

Pls reply as fast as possible

Sella

 

Answer 7

 

Hi,

 

I installed VS 2005 ..with this i got SQL Server 2005...

As  i am getting the above error...

So i installed sql server 2005 alone..and tried...i am getting the same error again..

 

Is there any way to remove this error...

 

Sella

Answer 8

 

Sella,

 

You can download Microsoft SQL Server 2005 Express Edition with Advanced Services from the following URL (which includes Reporting Services... be sure that it is selected during the install process):

 

http://www.microsoft.com/downloads/details.aspx?familyid=4C6BA9FD-319A-4887-BC75-3B02B5E48A40&displaylang=en

 

After further investigation, it looks like this error was being caused by installing Reporting Services on the Database tier instead of the application tier (or TFS Server). Please be sure that Reporting Services is installed on the same server as the web front end for TFS.

 

If this doesn't solve your problem, please let me know and I will investigate further.

 

Thank you,

 

Anthony Mallgren

Novorum Consulting Inc

Answer 9

 

I'm trying to Install TFS 2008 on a 32 bit Winddows 2003 R2 Server with the SQL Server residing on a 64 bit windows 2008 based SQL Server that does have Reporting Services installed.

When I'm being asked what database server I wish to connect to I get the TF220059 error. 

 

?????

 

What to do????

Answer 10

Reporting Service must be on the Application Tier of TFS (meaning the TFS server itself... the 32 bit Windows 2003 Server).

trip me up the first time as well :-).

Anthony Mallgren
Novorum Consulting Inc

Answer 11

Reporting Service does not have to be on the TFS 2008 application tier, although that's the default assumption. 

You can have Reporting Service on a machine other than the application tier by modifying the msiproperty.ini file.

Here's a link on how to do it:

http://blogs.msdn.com/sudhir/archive/2007/09/10/reporting-services-flexibility-orcas-rtm-only.aspx

 

Answer 12

 

I bumped into TF220059 while installing TFS as well... in my case, I had neglected to install the appropriate service pack for SQL Server 2005 prior to attempting to install TFS.  After installing SP2 for SQL '05, the install was able to proceed on....... to the next error. :-|

 

I hate Microsoft install routines.

Answer 13

I am getting the same error listed above.  I have installed Reporting services on my SQL machine.  I have installed SP2 on my SQL machine.  I've gone through the entire setup procedure step by step and am still getting this error.  Does anybody have any clue on why this still will not work?

 

Attempting Dual-Server deployment with TFS with Sharepoint on a Windows 2003 Standard Ed. with SP2 installed and SQL 2005 Standard edition on a Windows 2003 Stadard ED with SP2 installed as well.

 

[12:33:13.921] [0x00000001] TFS_SERVICE_ACCOUNT is not specified.
[12:33:13.921] [0x00000001] TFS_REPORTING_ACCOUNT is not specified.
[12:33:13.921] [0x00000001] [LCID]='1033'
[12:33:13.921] [0x00000001] [Server]='TFSSQL01.uhi.amerco'
[12:33:13.921] [0x00000001] [CurrentDir]='C:\Documents and Settings\tfssetup.UHI\Local Settings\SIT17655.tmp'
[12:33:13.921] [0x00000001] [INSTANCE_PREFIX]=''
[12:33:13.921] [0x00000001] [SERVICE_ROLE]='TFSEXECROLE'
[12:33:13.921] [0x00000001] [VSTF_AS_INSTANCE]='TFSSQL01.uhi.amerco'
[12:33:13.921] [0x00000001] [VSTF_AS_DATABASE]='TfsWarehouse'
[12:33:13.937] [0x00000001] CheckINTLcid.sql
[12:33:14.046] [0x00000001] CheckINT.sql
[12:33:14.062] [0x00000001] TfsIntegration DataStoreNotFound
[12:33:14.062] [0x00000001] CheckVC.sql
[12:33:14.062] [0x00000001] TfsVersionControl DataStoreNotFound
[12:33:14.062] [0x00000001] CheckWIT.sql
[12:33:14.062] [0x00000001] TfsWorkItemTracking DataStoreNotFound
[12:33:14.062] [0x00000001] CheckTB.sql
[12:33:14.078] [0x00000001] TfsBuild DataStoreNotFound
[12:33:14.078] [0x00000001] CheckWH.sql
[12:33:14.078] [0x00000001] TfsWarehouse DataStoreNotFound

Answer 14

Not so...reporting services can be installed anywhere.  You need to do a custom install to specify where the RS server is.  See the help section of TFSInstall called How to:  Customize Deployment of Team Foundation - it tells you how to specify where the RS server is located. 
Seemed to make sense to me  to install it on the SQL box, but you do need to install IIS in order to enable that option in the SQL Installer.

Answer 15

 

Hi there,

 

Does it require SQL 2005 reporting services?

 

Will it work with SQL 2000 reporting services?

 

Thanks,

Amit

 

Answer 16

Hi Codebased,

 

yes TFS2008 requires SQL 2005

 

http://msdn.microsoft.com/en-us/library/ms400745(VS.80).aspx

 

--Aaron

 

Answer 17

I resolved the problem by installing these services on the TFS server :

- SQL Server Integration Services
- SQL-full TEXT Search
- SQL Server Analysis Services
- SQL Reporting Services
- SQL Server Browser

i also had to define in the ...etc\hosts   file the TFS server hostname with IP address.

and make sure they are running.

Good luck !