How to: Upgrade TFS data tier to SQL Server 2008

Many customers asked about how to upgrade the TFS DT to SQL Server 2008. I’m writing this post  in the hope of that other TFS administrators can get a quick help. The following are steps to upgraded the TFS DT:

  1. Apply TFS 2008 SP1 if you haven’t applied it yet. TFS 2008 SP1 is a must in order to work with SQL Server 2008.
  2. Follow the document How to: Upgrade to SQL Server 2008 (Setup) to upgrade the database.
  3. Open the installation folder of TFS, find the configuration file Web Services\Warehouse\web.config.
  4. Modify the assembly binding redirection of Microsoft.AnalysisServices from <bindingRedirect oldVersion="9.0.242.0" newVersion="9.0.242.0"/> to <bindingRedirect oldVersion="9.0.242.0" newVersion="10.0.0.0"/>.
  5. Perform the step #4 for the Toos\SetupWarehouse.exe.config and Toos\TfsAdminUtil.exe.config.
  6. If some reports from the default MSF for Agile or MSF for CMMI template don’t work after the database upgrade, you might want to look at Issues with TFS 2008 built-in reports using SQL Server Reporting Services 2008

19 comments:

mark dot cleary at syncsoft com au July 27, 2009 at 8:22 PM

Bill,

Thanks for that post. We are hitting a problem where we get an error upgrading the warehouse. I've tried changing newVersion attributes as you suggested but the error doesn't go away, and the newVersion keeps getting reset to needed10found9. The error indicates it actually found 10 because it prints the version number. Also the -asacct parameter is blank which isn't correct.
Any ideas?

-mark

[12:28:05.897] [0x00000001] Upgrading the Warehouse Database (TfsWarehouse)
[12:28:05.897] [0x00000001] D:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\SetupWarehouse.exe
[12:28:05.897] [0x00000001] -upgrade -int TfsIntegration -s TFS-Store\TEAMX -d TfsWarehouse -c "D:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\Warehouseschema.xml" -a "SYNCSOFT\TFSService" -ra "SYNCSOFT\TFSSQL" -asinst "TFS-Store\TEAMX" -asdbname "TfsWarehouse" -asacct ""
[12:28:05.960] [0x00000001] D:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\SetupWarehouse.exe -upgrade -int TfsIntegration -s TFS-Store\TEAMX -d TfsWarehouse -c "D:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\Warehouseschema.xml" -a "SYNCSOFT\TFSService" -ra "SYNCSOFT\TFSSQL" -asinst "TFS-Store\TEAMX" -asdbname "TfsWarehouse" -asacct ""
[12:28:08.506] [0x00000003] An unexpected error occurred: Cannot connect to Analysis Services version '10.0.2531.0'.
[12:28:08.506] [0x00000001] 5
[12:28:08.506] [0x00000003] D:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\SetupWarehouse.exe 5 2594
[12:28:08.522] [0x00000003] Microsoft.TeamFoundation.DatabaseInstaller.DatabaseException: D:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\SetupWarehouse.exe 5 2594
at Microsoft.TeamFoundation.DatabaseInstaller.ProcessDeployer.ExecuteCommand(String filePath, String arguments, Boolean continueOnError)

guangming April 25, 2010 at 7:11 PM

Discount Handbags On Sale-Beautycasa Online : Official online destination for all things Louis Vuitton Handbags and purses including Luxury Handbags trends, designer reviews, handbag deals, and more.Hot sale Cheap cell phonesand cell phone china on our site! Fashion look and powerful functions for these mobile phones even discount cell phones! Wholesale HiPhone, 3G cell phones, PDA/Smart Phone now.China Cell PhonesDon't miss these cellphone!toy wholesale

antywong September 10, 2010 at 10:58 PM

The Louis Vuitton ARTSY MM with a lot of book is along with the famous figure; just we can know the charm of Louis Vuitton Damier Ebene Canvas Sac Plat. The brand always try its best to makes people life better, no matter cheap lv which role you play in the society ,the Louis Vuitton Cabas Rivington will give you the best nengha100911.

andre12323 March 30, 2011 at 2:20 AM

dsquareddsquared
dsquared shoesdsquared shoes
dsquared jeansdsquared jeans
dsquared jeans 2011dsquared jeans 2011
dsquared shoes 2011dsquared shoes 2011
dsquared jeans womendsquared jeans women
asics shoes saleasics shoes sale
asics shoesasics shoes
asics running shoesasics running shoes
asics mexico 66asics mexico 66
onitsuka mexico 66onitsuka mexico 66
asics onitsuka mexico 66asics onitsuka mexico 66
asics whizzerasics whizzer
asics japanasics japan
asics ultimate 81asics ultimate 81
onitsuka coolidgeonitsuka coolidge
rotation 77rotation 77
asics topasics top
asics miniasics mini
asics olymposasics olympos
onitsuka kanuchionitsuka kanuchi
timberland bootstimberland boots
christian louboutin shoeschristian louboutin shoes
karen millen dresseskaren millen dresses
maillot marseille 2011maillot marseille 2011

vibrams May 30, 2011 at 9:08 PM

All the cheap Christian Louboutin Heel for selling within our shop would be to provide services of first-class quality. you can take satisfaction in a whole lot more discount.The christian louboutin evening Platform whole lot could be the good and stylish one.They occur in fascinating style and design and stylish christian louboutin peep toe.These women's christian louboutin pumps are luxury and noble.The pump display formal, a whole lot more display its gorgeous gloss and honour. good heel with thick soles collocation to strengthen all round modelling, carry into some mysterious alluring taste! This pairs of large christian louboutin wedges features a pretty significant part for women's fabulous entire body figure, display their fantastic figure and stylish attitude.Welcome to share Christian Louboutin Store!

truddy June 14, 2011 at 8:26 AM

Louboutins shoes are regarded as as since the symbol of sexy and classy.Christian Louboutin names after a famous shoes designer who launched his line of high-end women's shoes. Now come to Louboutin UK store! We will change you into a gorgeous girl! Here provides Discount Christian Louboutin Sandals,Cheap Christian Louboutin,Louboutin Mens Collection and so on.The unique and well-Designed shoes favored by the world, signed with the Christian Louboutin red soles of the mark, giving high heels and covetable accessories, system pumps and elegant luxury Christian Louboutin clutch has to be available almost all fashion only. We now provide Christian Louboutin shoes with free shipping and save 60% off! Hurry up! Christian Louboutin UK store is your first choice!

jelish June 17, 2011 at 7:13 PM

Dear friends,Cheap Sale Louboutin online.All shoes elegant shoes is one of masterpiece from Christian Louboutin Evenings. When you buy yourself a pair of Christian Louboutin Pumps shoes you allow yourself to benefit from the vast experience and expertise that this brand has collected over the years.Christian Louboutin Slingbacks shoes is the personification of women,is their direct orgin of racial pride.Christian Louboutin Peep Toe shoes is the personification of women,is their direct orgin of racial pride.Welcome to our Louboutin 2011 stoer.http://www.sale-louboutin-shoes.us

jelish June 17, 2011 at 7:14 PM

Christian Louboutin Outlet Online Store offer 2011 new-style Christian Louboutin Sale Outlet online store.We will provide you with all kinds of CL.The Christian Louboutin Ankle Boots serve different functions and keep your feet stylish and warm,Christian Louboutin High Heels can always show our body in the best charming way, making her legs look as long as possible.Christian Louboutin New Style are the best choice for you to choose the brand, especially you want to keep steps to the fashion world.Christian Louboutin Peep Toes that are considered as classic due to the fact they are comfortable.Buy cheap Louboutin Outlet shoes, get your favorite.
http://www.christianlouboutinoutletonline.org

jelish July 11, 2011 at 8:22 PM

Welcome to the Christian Louboutin Outlet Online store. CL is the world's most famous high-heeled shoes. Women who wear it do not feel the same. Our Christian Louboutin Outlet stores offer a variety of CL. For example: 2011 Christian Louboutin, Christian Louboutin Ankle Boots, Christian Louboutin Heels, Christian Louboutin New Sandals, Christian Louboutin Peep-Toe, Christian Louboutin Pumps, Christian Louboutin Tall Boots. We will save you 80% of the money, thank you patronize hristian Christian Louboutin Outlet Online Store.

Comprare Xanax July 24, 2011 at 3:29 AM

Nice post! Thanks for sharing!

Nike soccer cleats July 31, 2011 at 7:59 AM

Ah good exciting content! Will always come to our attention. To bring you good news-works perfect! New nike soccer shoes best shoes 2011!!

Stacey August 11, 2011 at 8:05 AM
This comment has been removed by the author.
sping.chen August 30, 2011 at 8:37 AM

This Nike mercurial vapor ultra vibrant Nike mercurial vapor fg...The Nike vapor soccer shoes has a huge army of fans across the globe, Best Soccer Cleats and if you're one of them we know you love them to be bright, flashy and Nike Football Cleats in-your-face colours.

nike mercurial soccer cleats September 6, 2011 at 4:19 AM

Ah good exciting content! Will always come to our attention. To bring you good news-works perfect! So how is the Nike Football Cleats cleatschanged? the original Nike Speed boot!New products Nike Mercurial Vapor Superfly for us.the new Vapor football boots have undergone the same new paint work as the nike mercurial vapor superfly III and now feature the Nike Football Boots updated asymmetric.

Small Business IT Support London December 15, 2012 at 3:44 AM

It’s a great blog to visit because it’s like a learning experience and building the confidence up.
Small Business IT Support London

fdhty April 23, 2013 at 6:52 PM

Good love makes you see the whole world from one person while bad love makes you abandon the whole world for one person Ultimate Game Card, Men love from overlooking while women love from looking up. If love is a mountain, then if men go up, more women they will see while womenwill see fewer men Cheap Minecraft Gift Code, if you leave me, please don't comfort me because each sewing has to meet stinging pain Ultimate Game Card.

I know someone in the world is waiting for me, although I've no idea of who he is. But I feel happy every day for this 4story Gold, If a woman is not sexy, she needs emotion; if she is not emotional, she needs reason 4story Luna, in this world, only those men who really feel happy can give women happiness 4story Gold.

China tours June 18, 2013 at 8:47 PM

That is really cool. Thanks for finding it. Some really good ideas there, this is going to be a real time sink. I am a china tour lover,You can learn more: China and Asia tour packages | China vacation packages

Learn Chinese April 26, 2015 at 8:51 PM

The best place to study mandarin online is in China. However, we understand that it isn't always possible to move here to study Chinese language. The next best thing is to study with our experienced teachers in a virtual classroom. Online students enjoy the same excellent way of mandarin online lesson and custom designed courseware that we provide for our face to face clients.