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.
8 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)
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!
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
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!
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