TFS 2008/ Setupwarehouse command would fail after upgrading SQL

As part of upgrading SQL 2005 to 2008, you are required to recreate the TFSwarehouse cube. When the Setupwarehouse.exe command is ran you might see the following error:

"An unexpected error occurred: Error encountered when creating connection to Analysis Services. Contact your Team Foundation Server administrator"


Edit the application configuration file for Setupwarehouse.exe.

You can find setupwarehouse.exe.config file typically at %Program Files%\Microsoft Visual Studio 2008 Team Foundation Server\Tools

Change the newVersion attribute from to


This would happen if you have upgraded SQL 2005 to SQL 2008

SQL upgade will not update configure file of the Setupwarehouse.exe it would still have newVersion as ""

Content by: Romitg

Reviewed by: Lucky

Skip to main content