Geeks With Blogs
ET's VS and TFS World Fascinating tidbits about VS and TFS and .NET (well I hope...)

 

 

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 | Back to top


Comments on this post: SQL 2008 + TFS 2008 SP1 the lowdown…

# WMI Exceptions on repair
Requesting Gravatar...
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.
Left by Oren Novotny on Aug 16, 2008 1:46 PM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
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....
Left by Oren Novotny on Aug 16, 2008 2:01 PM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
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
Left by ET on Aug 18, 2008 9:07 AM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
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.
Left by Geoff Orr on Dec 16, 2008 12:47 AM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
Glad to hear it Geoff. It is indeed to hard. It will be much easier in 2010 believe me.

Cheers,

ET
Left by ET on Dec 16, 2008 8:54 AM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
Great and inspirational stuff!
Thanks for sharing.
Left by dll on Mar 14, 2009 10:49 AM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
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!
Left by Blake on Jun 24, 2009 9:06 AM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
Thanks Blake. I'll update. Glad it helped you.

Cheers,

ET
Left by ET on Jun 24, 2009 10:28 AM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
I recall seeing that also. Thanks for the info.
Left by ET on Sep 22, 2009 9:58 AM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
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.

Left by Matthew on Sep 25, 2009 10:38 PM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
Ok i've added to the blog post thanks Matthew.
Left by ET on Sep 28, 2009 8:56 AM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
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.
Left by Jane on Sep 29, 2009 11:11 AM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
Add/remove program click choose TFS and click change, then select repair.

Cheers,

ET
Left by ET on Sep 29, 2009 11:30 AM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
Thanks!

I thought it had to do with calling the different tools (ie. TFSAdminUtil).
Left by Jane on Sep 29, 2009 12:40 PM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
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?
Left by Jane on Sep 30, 2009 10:43 AM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
'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
Left by naruto shippuden on Nov 12, 2009 1:05 PM

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

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
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 ???
Left by Lizbeth Morales on Jun 03, 2010 11:53 AM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
I have the same problem as you do. I'll try to do this with mine.

Thanks for sharing
Left by Volcano Vaporizers on Sep 15, 2010 11:02 AM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
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.
Left by high pr text links on Sep 20, 2010 1:01 AM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
best idea
Left by hosting paper on Sep 24, 2010 5:43 AM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
Hey thanks for sharing this information, it is helpful...
Left by blackhawk tactical on Oct 06, 2010 2:34 AM

# Mrs
Requesting Gravatar...
Fantastic Help. Thank you for the excellent post.
Left by Sally Mundy on Oct 06, 2010 7:01 AM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
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.
Left by Custom Home Builders Bastrop on Sep 24, 2011 4:38 PM

# Good Information
Requesting Gravatar...
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.
Left by Waterproofing Systems on Sep 26, 2011 7:04 AM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
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 .
Left by nitin on Sep 30, 2011 7:13 AM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
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
Left by breakdown cover comparison on Oct 10, 2011 6:29 AM

# info
Requesting Gravatar...
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.
Left by big dog motorcycles on Oct 22, 2011 10:09 AM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
I am very much happy for using the great technology in this blog.
Left by somerset west property on Nov 01, 2011 11:26 AM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
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.
Left by Pest Control on Dec 12, 2011 1:49 AM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
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.
Left by Cooling Tower on Dec 27, 2011 4:11 AM

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

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
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.
Left by Swimming Pool Builders on Dec 28, 2011 3:31 AM

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

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
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.
Left by essay writing UK on Feb 04, 2012 8:58 AM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...


• 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

Left by Dissertation ghostwriting on Feb 10, 2012 6:58 AM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
Nice post...
Very helpful posting.......
Left by NIks on Feb 14, 2012 12:44 AM

# blog of the day
Requesting Gravatar...
Thanks for an insightful post. These tips are really helpful. Again thanks for sharing your knowledge with us.Keep up the good work.
Left by regalos aniversario on Mar 04, 2012 3:02 PM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
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
Left by juegos de bob esponja on Mar 08, 2012 12:52 AM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
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
Left by shop vac filter on Mar 14, 2012 4:39 AM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
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,
Left by agua oficina on Mar 22, 2012 5:16 AM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
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.
Left by comprar behringer on Apr 02, 2012 4:51 PM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
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.
Left by gps barato on May 27, 2012 7:28 AM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
draw a portrait like Charlie Brown and red-haired girl
Left by and this is great on Jun 02, 2012 8:50 AM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
Very good post. I have been searching for this post since many days. Now I have implemented the same for my site.
Left by tienda de decoración on Jun 07, 2012 12:20 AM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
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.
Left by Occupational Road Risk on Jun 13, 2012 2:52 AM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
create a thank-you card with my company logo using MS Publisher
Left by having a bad day on Jun 20, 2012 8:14 AM

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
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
Left by tienda acuario on Jul 01, 2012 11:28 AM

# inspired info
Requesting Gravatar...
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.
Left by banderolas farolas on Jul 09, 2012 8:53 PM

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

# re: SQL 2008 + TFS 2008 SP1 the lowdown…
Requesting Gravatar...
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.
Left by resume layouts on Sep 13, 2012 11:52 AM

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

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

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

Your comment:
 (will show your gravatar)


Copyright © Etienne Tremblay | Powered by: GeeksWithBlogs.net | Join free