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 22.214.171.124 to 10.0.0.0.
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 “126.96.36.199”
Content by: Romitg
Reviewed by: Lucky