ET's VS and TFS World

Fascinating tidbits about VS and TFS and .NET (well I hope...)

  Home  |   Contact  |   Syndication    |   Login
  172 Posts | 0 Stories | 189 Comments | 118 Trackbacks

News



View Étienne Tremblay's profile on LinkedIn

Twitter












Tag Cloud


Archives

Post Categories

Image Galleries

My Friends

My Links

 

 

Hello everyone,

With SQL 2008 shipping late last week it was time to try my hands at this scenario.  It worked great but with a few things to remember.  Here is the lowdown.

There are two way to go about in order to install TFS with SQL 2008 1) Fresh install, 2) Upgrade SQL.

1) Fresh Install

I used Windows 2008 because this is going to be the prevalent OS to install on when people are going to start fresh or it most likely will.  There was a little issue with that install when Windows 2008 RTM’ed back in February and I talked about it in this post.  I wanted to see if the WSS issue was resolved in SP1.  Well the good news is yes.  When installing TFS, the experience is now the same for Windows 2003 and Windows 2008 and to boot, the SP1 now updates the WSS bits on the RTM DVD to WSS 3.0 SP1.  Cool.

The problem is SQL 2008 now.  You can’t use TFS 2008 RTM to install with SQL 2008.  You need to slipstream (or Integrate) the SP on top of the RTM bits.  The new install instruction covers this but here is a step by step.

a) Copy the original Media to a folder on any machine say d:\tfs\RTM

b) Extract the SP to a folder say d:\tfs\SPExtract

D:\SP1Download\TFS90SP1-KB949786-ENU /extract:d:\tfs\SP1Extract

c) Create a directory to put the result of the integration in say d:\tfs\ATIntegrated

d) Integrate (slipstream) the SP to the AT install by using this command line (note if you are in Windows 2008 make sure you start you console window as an Administrator or you’ll get prompted by UAC when executing the command).

msiexec /a d:\TFS\RTM\AT\vs_setup.msi /p d:\TFS\SP1Extract\TFS90sp1-KB949786.msp TARGETDIR=d:\TFS\ATIntegrated

e) Once you have done this make sure you copy back the ATIntegrated content to the original AT in the d:\TFS\RTM\AT overriding the original content. 

Now you might be tempted to do the same integration with the Build and Proxy directory since they both have a vs_setup.msi file I know I was and actually did.  You can’t.  I works (well it looks like it does) but when you run the setup, it fails miserably.  This is documented by Microsoft to NOT do that for Build and Proxy.  You need to install the RTM version and then run the SP on top of it.  It would have been nice to have a new DVD with all component SP’ed but it’s not to be.

f) After you have copied back the content to the original RTM directory, just burn a new ISO or DVD and you’re ready to install it.

NOT QUITE…

If you want to have Team Explorer (TE) on your server to create new project like I do, you need to install it BEFORE you install SQL 2008 and apply the TE SP1 also before IF you want to install the client tools as part of the SQL 2008 install which you most likely will to manage backups and verify tables, etc.  This problem is fully explained in this KB, Visual Studio 2008 SP1 may be required for SQL Server 2008 installations. If you want to create an all in one server with Studio and Build for example you need to follow the same procedure.  Here is an ordered list;

i) Windows (2003/2008) + IIS

ii) VSTS and/or TE 2008

iii) SP1 of VSTS and/or TE (it’s the same one that installs for all version of VS/VS Core, you need to run it once for anything component you have installed)

iv) SQL 2008 + Component like DB, RS, AS, Client Tools, etc (follow the install guide instructions, i'll try to post an unattended install file when I have one)

v) TFS SP1 (integrated), this will now install WSS properly for both Windows 2003 and Windows 2008 so no need to install it before.

vi) TFS Build + TFS SP1 (which is a different SP then the VS one)

vii) TFS Proxy + TFS SP1

viii) Office components (note this can be anytime I just like to install at the end)

You should then be in business… at least I was.  It took about 3h considering I already had a base 2008 VM.  The SP takes a long time to install but it works fine.  Double-click and wait.

Note that this is the way I did it.  I just read a few minutes ago that if you are starting fresh you can install SQL 2008 with everything you need and then install VS on top of it and then apply the SP.  That sounds weird to me since a version of VS SP will be already installed when you try to install VSTS RTM… would that work… I haven’t tried.  According to Aaron it should… Hold off on installing SQL 2008 if you have Visual Studio 2008 RTM installed - for now (see on the bottom of this post).  I know what I just documented works I’ve done that.

 

2) Upgrade SQL

Well that’s a bit trickier, Chris Rathjen from Microsoft sent me this info about that upgrade path

i. Start downtime

ii. Upgrade SQL2005 to SQL2008; AT will stop working at this step

iii. Apply TFS SP1 (and VS sp1 if the client is on the AT); AT will work again

iv. Verify full functionality

v. End downtime

 

If you apply SP1 before the upgrade, there’s an extra step:

i. Start downtime

ii. Apply TFS SP1 (and client…)

iii. Upgrade SQL2005 to SQL2008; AT will stop working at this step

iv. Repair TFS AT; AT will work again

v. Verify functionality

vi. End downtime

Well there you have it a somewhat complete picture of the upgrades and installs of the various Service Packs.  It was much less painful than the VS 2005 experience and I have to give kudos to Microsoft for that.  That was a hard experience.  I hope this will be useful to you, and don’t hesitate to leave me a comment if you have any issues and I will get answers for you.

 

Update 28/09/2009

Matthew had a good comment on SQL 2008 SP1.  You need to do a bit more hacking to get TFS 2008 SP1 to install on an SQL 2008 SP1.  Follow the instructions available in this KB: How to install Microsoft Visual Studio 2008 Team Foundation Server on a computer that has SQL Server 2008 Service Pack 1 installed

Good luck,

ET

posted on Monday, August 11, 2008 11:51 AM

Feedback

# WMI Exceptions on repair 8/16/2008 1:46 PM Oren Novotny
I just wanted to let you know (for others' benefit), that using a custom hostname for RS, the SP1 re-apply failed.

It was choking on the TFRSConfig command and the CreateDS commands. The easiest way I found to workaround it (brute force) was during the repair, to make a backup copy of those files and sub-in a dummy program with the same name that does nothing. That fooled the installer into finishing.

I already configured RS correctly, so there's no need for the installer to do it for me...

I'm not sure the real solution, but that seems to have worked. Of course, once the install was done, the dummy programs can be removed and the originals renamed back.

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 8/16/2008 2:01 PM Oren Novotny
Oh, I should add that when I installed the SP, it worked just fine w/o any errors. Then, I'd upgraded to RS / SQL 2008 on the AT then the DT. When I went to repair the install, that's when I got into issues with RS....

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 8/18/2008 9:07 AM ET
ahhh the friendly name... So I've been following an internal trend on your exact problem. Seems you might have to run tfsadminutil configureconnections and put in the netbios name for the WSS and RS before running the upgrade, then when the upgrade is done, run it again to put it back the friendly name. Something about WMI interpreting a '.' as an external address instead of a local address. Hopefully that will help a few folks out there.

Cheers,

ET

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 12/16/2008 12:47 AM Geoff Orr
Thanks that got me over the hump. I got the 29110 error until I used this process. I still think this is harder than it should be.

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 12/16/2008 8:54 AM ET
Glad to hear it Geoff. It is indeed to hard. It will be much easier in 2010 believe me.

Cheers,

ET

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 3/14/2009 10:49 AM dll
Great and inspirational stuff!
Thanks for sharing.

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 6/24/2009 9:06 AM Blake
Not that this would stop anyone, but...it might be good to correct to make things easier:

If I follow your example, the command under 1d isn't quite right. It should be:

msiexec /a d:\TFS\RTM\AT\vs_setup.msi /p d:\TFS\SPExtract\TFS90sp1-KB949786.msp TARGETDIR=d:\TFS\ATIntegrated

Right now it has C:\ instead of d:\ and "SP1Extract" instead of the "SPExtract" you name in your example.

Hope that's as helpful to you as your article has been to me. Thanks!

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 6/24/2009 10:28 AM ET
Thanks Blake. I'll update. Glad it helped you.

Cheers,

ET

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 9/22/2009 9:58 AM ET
I recall seeing that also. Thanks for the info.

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 9/25/2009 10:38 PM Matthew
Yeah...something that is seriously missing from this wonderful article AND from the install guide. The genius who patched TFS SP1 to work with SQL 2008 failed to account for any future SP's for SQL.

http://support.microsoft.com/default.aspx/kb/969985

In the event you happened to run Windows Update and you are running SQL 2008 SP1 before installing TFS then slipstreaming isn't enough. You need to manually edit an XML file.



# re: SQL 2008 + TFS 2008 SP1 the lowdown… 9/28/2009 8:56 AM ET
Ok i've added to the blog post thanks Matthew.

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 9/29/2009 11:11 AM Jane
Regarding these steps:

If you apply SP1 before the upgrade, there’s an extra step:
i. Start downtime
ii. Apply TFS SP1 (and client…)
iii. Upgrade SQL2005 to SQL2008; AT will stop working at this step
iv. Repair TFS AT; AT will work again
v. Verify functionality
vi. End downtime

Where can I find steps to repair the TFS AT?

I'm relatively new to TFS and I'm still trying to figure everything out.

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 9/29/2009 11:30 AM ET
Add/remove program click choose TFS and click change, then select repair.

Cheers,

ET


# re: SQL 2008 + TFS 2008 SP1 the lowdown… 9/29/2009 12:40 PM Jane
Thanks!

I thought it had to do with calling the different tools (ie. TFSAdminUtil).

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 9/30/2009 10:43 AM Jane
Sorry, I have another question.

When upgrading SQL 2005 to SQL 2008 on a server that already has TFS 2008 SP1, which option did you select during the upgrade wizard for "Full-text upgrade"?

Import or upgrade?

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 11/12/2009 1:05 PM naruto shippuden
've been following an internal trend on your exact problem. Seems you might have to run tfsadminutil configureconnections and put in the netbios name for the WSS and RS

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 5/12/2010 6:40 AM Boiler Manuals
Hey, thanks for comparing both ways. Gave me much to think about.

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 6/3/2010 11:53 AM Lizbeth Morales
The d) step got failed saying that " The upgrade patch cannot be installed by the Windows Installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the Program. Verify that the program to be upgraded exists on your computer and that you have the correct upgraded patch." why??? i need a specify version of Windows Installer ???

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 9/15/2010 11:02 AM Volcano Vaporizers
I have the same problem as you do. I'll try to do this with mine.

Thanks for sharing

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 9/20/2010 1:01 AM high pr text links
An invaluable resource and great addition to my favorites. The new features are well received on this end and will surely help the community share and progress more rapidly.

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 9/24/2010 5:43 AM hosting paper
best idea

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 10/6/2010 2:34 AM blackhawk tactical
Hey thanks for sharing this information, it is helpful...

# Mrs 10/6/2010 7:01 AM Sally Mundy
Fantastic Help. Thank you for the excellent post.

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 9/24/2011 4:38 PM Custom Home Builders Bastrop
Hey that’s a very nice article and I really attract with this article the reason is that I get many information from this article. So thanks for posting me.

# Good Information 9/26/2011 7:04 AM Waterproofing Systems
Thanks for sharing this informative post with us.
Fairmate Chemicals Pvt. Ltd. Is manufacturing the industrial Construction Chemicals, Waterproofing Systems, Concrete Admixture, Industrial Flooring, Surface Treatment Systems and markets specialty chemicals for civil engineering industry.We are ISO 9001 , 14001 certified company.

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 9/30/2011 7:13 AM nitin
Thank you it is good material to read this post increases my knowledge
What a wonderful piece of information Admiring the time and effort you put into your blog and detailed information you offer! I will bookmark your blog and have my children check up here often. Thumbs up!
Thanks this post really opened my eyes. it is not only eye opening rather very beneficial for the people those who want to do something good in his life .


# re: SQL 2008 + TFS 2008 SP1 the lowdown… 10/10/2011 6:29 AM breakdown cover comparison
Very informative article. You have both insight as well as courage to say the right thing in a proper manner. You may call it a coincidence but we also thought about the same thing. Any way, i wish to share with you a remarkable development in the field of cyber law in India.I am very glad that I find your regular post here. Which seems to be very important and it made good time pass for me. I will always give a nice thrust look in to you from my bookmark feed. I don't actually comment and don't like to spend time in typing the comment. But here I have to do this because this one deserves a good like

# info 10/22/2011 10:09 AM big dog motorcycles
I wanted to thank you for this great blog! I really enjoying every little bit of it and I have you bookmarked to check out new stuff you post.

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 11/1/2011 11:26 AM somerset west property
I am very much happy for using the great technology in this blog.

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 12/12/2011 1:49 AM Pest Control
Thanks for sharing this blog post with us.
Pestcone is a Pest control company located in India, which offers wide range of affordable pest control services for residential and commercial buildings across the India. We provide both commercial and home pest control services and help you in pest and termite prevention by using various effective and safe pest control products. We specialize in protecting your house and commercial buildings from reptiles with the help of quality reptile control services.

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 12/27/2011 4:11 AM Cooling Tower
The cooling tower construction company provides the complete solutions for business and industrial cooling requirements. Netra Infra Tech specialize in frp cooling tower installation, design, water treatment.


# re: SQL 2008 + TFS 2008 SP1 the lowdown… 12/27/2011 6:28 AM Web Hosting Service
Best website designing company in waterloo, which provide web development, web hosting and web promotion services with affordable rates in Canada.


# re: SQL 2008 + TFS 2008 SP1 the lowdown… 12/28/2011 3:31 AM Swimming Pool Builders
All Seasons Pool - Inground Pool - provides pool services in Central Florida, North Florida and Orlando. All Seasons Pools gives quality pool construction, custom swimming pool installation, new in ground pool builders, quality swimming pools and spas for both commercial clients and homeowners.


# re: SQL 2008 + TFS 2008 SP1 the lowdown… 1/30/2012 5:28 AM Essay writing services ratings
The article written very professionally, highly appreciate and will share on face book.

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 2/4/2012 8:58 AM essay writing UK
Today when i wakeup i feel very lazy due to browsing last whole day but now i feel happy because my searching comes to end after reading your article.


# re: SQL 2008 + TFS 2008 SP1 the lowdown… 2/10/2012 6:58 AM Dissertation ghostwriting


• Subsequently, after spending many hours on the internet at last We've uncovered an individual that definitely does know what they are discussing many thanks a great deal wonderful postDissertation ghostwriting



# re: SQL 2008 + TFS 2008 SP1 the lowdown… 2/14/2012 12:44 AM NIks
Nice post...
Very helpful posting.......


# blog of the day 3/4/2012 3:02 PM regalos aniversario
Thanks for an insightful post. These tips are really helpful. Again thanks for sharing your knowledge with us.Keep up the good work.

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 3/8/2012 12:52 AM juegos de bob esponja
North Florida and Orlando. All Seasons Pools gives quality pool construction, custom swimming pool installation, new in ground pool builders, quality swimming pools and spas fo

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 3/14/2012 4:39 AM shop vac filter
I became pleased to uncover this great site. I desired by way of thanking you just for this great read!! I definitely enjoying every little it and i also maybe you've bookmarked to see new things you post

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 3/22/2012 5:16 AM agua oficina
The road is paved and you do not need to worry about hairpin turns, but slow speeds are necessary because the road is narrow and travels along steep ridges. Thanks a lot.
Regards,

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 4/2/2012 4:51 PM comprar behringer
I don’t know what to say. This blog is fantastic. That’s not really a really huge statement, but its all I could come up with after reading this. You know so much about this subject. So much so that you made me want to learn more about it. Your blog is my stepping stone, my friend. Thanks for the heads up on this subject.

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 5/27/2012 7:28 AM gps barato
I have read some excellent stuff here. Certainly price bookmarking for revisiting. I surprise how so much attempt you put to make this sort of great informative web site.

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 6/2/2012 8:50 AM and this is great
draw a portrait like Charlie Brown and red-haired girl

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 6/7/2012 12:20 AM tienda de decoración
Very good post. I have been searching for this post since many days. Now I have implemented the same for my site.


# re: SQL 2008 + TFS 2008 SP1 the lowdown… 6/13/2012 2:52 AM Occupational Road Risk
This is an excellent post. It's having good description regarding this topic.It is informative and helpful.I have known many information from this.

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 6/20/2012 8:14 AM having a bad day
create a thank-you card with my company logo using MS Publisher

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 7/1/2012 11:28 AM tienda acuario
So nice post, it is so interesting.. Plug in transformers which can help in saving power and energy can be purchased from Pico electronics, New York. For more detailed information visit its website

# inspired info 7/9/2012 8:53 PM banderolas farolas
Thanks for a good share of which you have given us such a large collection of information. Great work you have done through the sharing of them all.Simple operation has brought us such a good platform.I think this is valuable for us are very grateful to your help.

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 7/10/2012 2:53 PM penny auctions
There was so many lie there, we must keep searching the truth about that, we must know all of it.

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 9/13/2012 11:52 AM resume layouts
The following topics are the minimum hardware and software requirements needed to install and run SQL Server 2008.
The following requirements apply to 32-bit and 64-bit versions of SQL Server 2008. Thank you for the article.

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 9/17/2012 9:24 AM standard resume layout
very nice article, thank you for this blog. much useful information for me.

# re: SQL 2008 + TFS 2008 SP1 the lowdown… 9/20/2012 6:53 PM writing and editing services
Thanks for this informatioin. It's very useful for me. Now I know the facts!

# <a href="http://www.paseodelbebe.es/"> sillas de paseo </a> 9/22/2013 12:43 PM Peter
I love your blog, I recommend to all people who love this kind of post to visit this site.

Post A Comment
Title:
Name:
Email:
Comment:
Verification: