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"

Resolution

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 9.0.242.0 to 10.0.0.0.

Cause

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 "9.0.242.0"

Content by: Romitg

Reviewed by: Lucky