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:
- 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.
- Follow the document How to: Upgrade to SQL Server 2008 (Setup) to upgrade the database.
- Open the installation folder of TFS, find the configuration file Web Services\Warehouse\web.config.
- 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"/>.
- Perform the step #4 for the Toos\SetupWarehouse.exe.config and Toos\TfsAdminUtil.exe.config.
- 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.
17 comments:
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)
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
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.
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
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!
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!
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
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
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.
Nice post! Thanks for sharing!
Ah good exciting content! Will always come to our attention. To bring you good news-works perfect! New nike soccer shoes best shoes 2011!!
Excellent post. I was checking this blog continuously and I’m impressed! The information is very helpful especially the last part. I am very interested in such info. I was seeking this particular information for a very long time. Thank you and good luck.Web Application Development
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.
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.
Discount Uggs
Discount Ugg Boots
Ugg Boots Discount
Uggs Discount
Discount Uggs Boots
It’s a great blog to visit because it’s like a learning experience and building the confidence up.
Small Business IT Support London
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.
Post a Comment