TF220064 when trying to upgrade to TFS 2008
I you received:
TF220064: An error occurred while the Setup program was querying the settings from the server that is running SQL Server Reporting Services. This error is most likely caused by your account not having the required administrative permissions on the server that is running Reporting Services. Click Next to try again. 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.
Cause:
You probably use FQDN names for your reporting services server as explained here.
Workaround:
Change URI for the ReportsService to use a NETBIOS name instead of a fully qualified domain name (FQDN) - and revert it back after successful setup.
(Special thanks to Daniel Hackel who administers this environment and had to go all the upgrade trouble as well.)