Install Guide: SP2 for SharePoint (WSS v3 and MOSS 2007)

Service Pack 2 was released today (as I am guessing the whole world knows by now). Instead of making that profound announcement I would recommend you check out this post on the SharePoint Team blog for the official announcement. I will spare you the crazy details other than you should install it. J

Just like when the last updates came out I figured I would write a quick guide on the steps I am taking to install. Something to ponder before you get started. When was the last time you did a backup? Knock on wood as you answer.

  1. Start time 11:11 PM
  2. I am checking Windows Update for the latest patches. Looks like SQL Server 2008 SP1, IE8, and a random other Office update is waiting to install. I think I will let them sit for another evening; I have to get up early in the morning.
  3. This environment is a single box with both MOSS Enterprise and SQL Server 2008. MOSS is currently running the February cumulative updates build 12.0.0.6341.
  4. Downloading WSS SP2. 32.9 MB in 29 seconds. Make sure you download the 32bit or 64bit version you need. Both are available from the linked page.
  5. Downloading MOSS SP2. 270 MB in 3 minutes 54 seconds. Make sure you download the 32bit or 64bit version you need. Both are available from the linked page.
  6. Launched the WSS SP2 EXE I just downloaded.
  7. Agreed to the license terms and clicked Continue
  8. Started 11:22 PM. Ended 11:24 PM.
  9. When configuration wizard opens click Cancel and Yes at the warning. We will run config wizard after the MOSS update is installed also.
  10. Launched the MOSS SP2 EXE I just downloaded
  11. Agreed to the license terms and clicked Continue
  12. Started 11:25 PM. Ended 11:36 PM.
  13. Configuration Wizard opens automatically when the update finished installing.
  14. Click Next at the welcome screen
  15. Click Yes to stopping IIS, SharePoint Admin Service, and SharePoint Timer Service
  16. Click Next at the completing screen
  17. You will get a popup warning that you need to install the updates on all servers in your farm before continuing. Be sure to do that if you have multiple servers.
  18. Click OK.
  19. Start at 11:38 PM. About 3 GB of content in this farm. End at 11:48 PM.
  20. Click Finish
  21. Looks like I am left with build 12.0.0.6421

Remember these are the steps I took on my server. They are put here to give you basic guidance, if you feel you want to read about applying updates in excruationing details then check out these links from the Team blog.

Deploy software updates for Windows SharePoint Services 3.0
http://technet.microsoft.com/en-us/library/cc288269.aspx

Deploy software updates for Office SharePoint Server 2007
http://technet.microsoft.com/en-us/library/cc263467.aspx

OK so a question for you. Do you like these update install guides with so many details or would you prefer I leave out everything and just make it quick. You really don’t care about my Windows updates or how long it takes to install?

Shane SharePoint Consulting



59 Comments so far

  1.   Aaron Navratil on June 18th, 2009          Reply

    These guides are excellent, and your articles are great!

  2.   eddie on June 21st, 2009          Reply

    very good! concise!

  3.   Bret on June 26th, 2009          Reply

    Exactly what I was looking for.

  4.   Jonas on June 30th, 2009          Reply

    Thanks for this, suprisingly hard to find a step-by-step guide! Even if it’s an easy process, it still is nice knowing you’re doing it right!

  5.   Jonahtan on July 2nd, 2009          Reply

    This was very helpful. Thanks.

  6.   Arjan Fraaij on July 28th, 2009          Reply

    Great website with real needed information. For sure a SharePoint almanac..

    Would like to recommend to look at http://support.microsoft.com/kb/971620/en-us for a issue with MOSS SP2

  7.   Damir on July 28th, 2009          Reply

    In my experience, when doing clean install with MOSS w SP1, upgrade to SP2 will fail if SSP is not created.

  8.   Shane on July 28th, 2009          Reply

    Damir I have heard of others having that issue but in the handful I have done I have not had that issue. Guess it just depends on its mood.

    Thanks

  9.   To Quiesce Farm or NOT to Quiesce Farm on August 1st, 2009          Reply

    Hey Shane,

    Question… Our company is working on upgrading to SP2 for MOSS for our external facing site.  Knowing that there could be connections on our web site at the time of the upgrade would it be a good idea to do a Quiesce Farm to close the connections to the farm first?

    Craig

  10.   Shane on August 4th, 2009          Reply

    Craig – Typically we stop the Web publishing service on all WFE to keep people away while we upgrade.

  11.   Karuana on August 20th, 2009          Reply

    I like your detail and especially like the notes on time… it helps me to know if something is stuck or just going alone like it should… not bad for planning my evening either!  Thanx for this.

    K.

  12.   Kelly on August 26th, 2009          Reply

    Hi Shane,
    I used your Inside SharePoint 2007 Admin Book I bought at Tech Ed (LA) to setup my new MOSS farm on W2008R2 and it worked great. Thanks!

    Question: When I install the cumulative updates for MOSS 2007, can I slipstream instead of running the executable?

  13.   Theo on September 3rd, 2009          Reply

    It did fail on me trying to install it one our DEV box which should have been a clone of TEST (which was succesful). In our case it turned out that there was a difference in available disk space. After making some space available it went through with no further errors… the error was; “An error has occured. Sorry for the inconveniance”, or something close that – thanx Microsoft. 🙂
    ANYWAY, just make sure you have at least 500mb diskspace left before you start.

    Thanx for the guide.

  14.   jc on September 9th, 2009          Reply

    Thank you This is valuable.

    Our production farm has 2 web front ends, the moss server, a clustered SQL 2005 server (so two nodes) and an SSRS server.

    We are not running SP1 yet in production.

    Our Test farm is also not on SP1 yet. On this farm we only have 1 WFE and the DB server is not clustered. Also, on the test farm, I’ve upgrade to version 9.0 of the SSRS SP Add-in to fix an unable to load print control issue. Product is still on v 8.0 of the add-in and still has the issue.

    We’d like to go straight to SP2 and would like try it on the Test Farm first.

    How will our upgrade plan differ? Which servers must we install it on? Other considerations?

    Mostly concerned about getting stuck and having the farm disabled with no easy way back.

  15.   Mark on September 17th, 2009          Reply

    Hi, I have over 500 MB of space but MOSS SP2 is presenting the ‘dreaded’ error message: Product: Microsoft Search Front End — Error 1307. There is not enough disk space to install this file: C:\Program Files\Microsoft Office Servers\12.0\Bin\nlslexicons000c.dll. Free some disk space and click Retry, or click Cancel to exit.

    Any helpful hints, direction, etc. would be appreciated. Thank you.

  16.   replica watches on September 27th, 2009          Reply
  17.   replica watches on September 27th, 2009          Reply
  18.   Merrarid on October 11th, 2009          Reply

    Very cute :-)))),

  19.   Olilith on October 12th, 2009          Reply

    Very interesting site. Hope it will always be alive!,

  20.   Barry Henry on October 26th, 2009          Reply

    Can patch kb971620 (trial date issue) be installed right after MOSS SP2 install but before running products and technologies configuration wizard?

    Thank you

  21.   Doctorset on November 20th, 2009          Reply

    This is the welcome page for the dentaldoctor.us Association web site.

  22.   Dietroly on November 21st, 2009          Reply

    This is the welcome page for the dietguidance.us Association web site.

  23.   Adam Tyler on November 27th, 2009          Reply

    This really helped. The time you enter for each install is a great detail. Keep it up!

    Adam Tyler, MCSE
    ATyler@roinc.com

  24.   Craig on December 3rd, 2009          Reply

    When I get to Step 17 I need to install the updates on the rest of the SharePoint WFE servers. Do you mean that I just need to install the WSS SP2 and MOSS SP2 and NOT run the configuration wizard for either update? Please let me know if my assumption is correct?

  25.   John on December 16th, 2009          Reply

    What is the best order to install SP2 in a mediun size farm with two dedicated FE and one dedicated indexer and one dedicated serach server? I would assume FE first.

  26.   Install Software on February 2nd, 2010          Reply

    Hi there.
    Great installation help…thanks, fixed my problem.
    Anyone reading this guys stuff should bookmark it.

  27.   Install Software on February 2nd, 2010          Reply

    Hi there.
    Great installation help…thanks, fixed my problem.
    Anyone reading this guys stuff should bookmark it.

  28.   Install Software on February 5th, 2010          Reply

    Another great post.
    Thanks for the tips and help.
    Everyone, bookmark this site.

  29.   Install Software on February 5th, 2010          Reply

    Another great post.
    Thanks for the tips and help.
    Everyone, bookmark this site.

  30.   Install Software on February 5th, 2010          Reply

    Another great post.
    Thanks for the tips and help.
    Everyone, bookmark this site.

  31.   Install Software on February 5th, 2010          Reply

    Another great post.
    Thanks for the tips and help.
    Everyone, bookmark this site.

  32.   Install Software on February 5th, 2010          Reply

    Another great post.
    Thanks for the tips and help.
    Everyone, bookmark this site.

  33.   Install Software on February 5th, 2010          Reply

    Another great post.
    Thanks for the tips and help.
    Everyone, bookmark this site.

  34.   Install Software on February 5th, 2010          Reply

    Another great post.
    Thanks for the tips and help.
    Everyone, bookmark this site.

  35.   Install Software on February 5th, 2010          Reply

    Another great post.
    Thanks for the tips and help.
    Everyone, bookmark this site.

  36.   Install Software on February 6th, 2010          Reply

    Another great post.
    Thanks for the tips and help.
    Everyone, bookmark this site.

  37.   Install Software on February 6th, 2010          Reply

    Another great post.
    Thanks for the tips and help.
    Everyone, bookmark this site.

  38.   Install Software on February 6th, 2010          Reply

    Another great post.
    Thanks for the tips and help.
    Everyone, bookmark this site.

  39.   Install Software on February 6th, 2010          Reply

    Another great post.
    Thanks for the tips and help.
    Everyone, bookmark this site.

  40.   Install Software on February 6th, 2010          Reply

    Another great post.
    Thanks for the tips and help.
    Everyone, bookmark this site.

  41.   Install Software on February 6th, 2010          Reply

    Another great post.
    Thanks for the tips and help.
    Everyone, bookmark this site.

  42.   penispillsenlargement on February 27th, 2010          Reply

    They are becoming the enhancement option of choice for many men for several reasons. vimax pills is the best penis enlargement pills on the market today.
    http://www.male-sexual.com/vimax-pills.htmlhttp://www.youtube.com/watch?v=pobXsnw7CWs

  43.   Solyman on March 5th, 2010          Reply

    Hi,

    thank you so much for your post, it is really helpful. I was wondering if SP2 will fix the issue with the Workflow Delay Activity? MS Support claims it does.

    Thanks again

    Solyman

  44.   Joao on April 14th, 2010          Reply

    Good Bloging about SP2 Deploy, better was impossible.!

  45.   Dedryver Maxime on April 26th, 2010          Reply

    Hi Shane,

    Thanks for the install guide SP2 MOSS 2007.

    However, I meet a problem to install the cumulative update (February 2010).
    The wizard indicates that :”The expected version of the product was not found on the system”.

    The farm version is 12.0.0.6421.

    Thank you for your help.

    Maxime

  46.   Dedryver Maxime on April 26th, 2010          Reply

    Hi Shane,

    Thanks for the install guide SP2 MOSS 2007.

    However, I meet a problem to install the cumulative update (February 2010).
    The wizard indicates that :”The expected version of the product was not found on the system”.

    The farm version is 12.0.0.6421.

    Thank you for your help.

    Maxime

  47.   Deanna McNeil on June 3rd, 2010          Reply

    Shane, thank you for this level of detail. Just what I needed even though I didn’t *cough* apply the service pack right away.

  48.   sam on June 9th, 2010          Reply

    Hi,

    Lots of useful information with a wealth of great resources. Helpful from start to finish.

    Thanks for sharing this info,
    Cheers,

  49.   Cat on October 13th, 2010          Reply

    I got the error below:
    Cannot find the object “DatabaseInformation” because it does not exist or you do not have permissions.

    Please help?

  50.   Conrad on October 21st, 2010          Reply

    Cat did you get a resolution? I have the same issue on a clone of my production environment, I’ve had to add the table dbo.DatabaseInformation such as it exists in other content databases, and generate a GUID for the Value column!

    This seems to allow the upgrade of the content database, but please be warned this is not supported by Microsoft.

    I will be contacting them for an appropriate resolution ASAP.

    Regards,

    Conrad Goodman

  51.   Fletch on October 27th, 2010          Reply

    Very handy little install guide. Thanks Shane.

  52.   Jamye on November 4th, 2010          Reply

    I know this is an older post, but…
    I have an older farm that I have inherited and I need to get it up to at least SP2 for the time being.

    I have read in a few other SP2 upgrade posts that you should detach the content databases. Is that really necessary if I have only one and it is less than 40GB? Out of curiosity, if you did detach, what is the benefit?

  53.   Pablo on December 7th, 2010          Reply

    Excelente quick guide!

    Pablo
    @pabloafain on Twitter

  54.   Wade Bradshaw on January 5th, 2011          Reply

    Thx again for the “down to earth” guide. The timing/duration info is helpful too. This is slightly off topic, but Theo (and anyone else), what software are you using to perform the refresh of content between your Production/Test-Staging/Dev environments? Thanks in advance.

  55.   Steve on January 15th, 2011          Reply

    Note: successfull completion of WSS Sp2 instalation, followed by successfull completion of Config Wizard, may nevertheless result in “Service Unavailable” when Config Wizard automatically connecting to CA page on completion of config. Administrators will see multiple instances of “Error 1059” messages appearing in System Event log. Resetting Application Pool identities may not resolve the problem, though the error points to this as the cause. The actual fix is simple: boot the machine.

  56.   Niyaz on May 9th, 2011          Reply

    Hi

    Appreciate about mentioned information.

    Could you please prove the steps to install CU in sharepoint farm in the following environment

    Appliacation server ( CA, Excel services and BDC)
    Insex server
    WFE

    Regards

  57.   Tracen on May 14th, 2011          Reply

    Hey, that’s the grtaeset! So with ll this brain power AWHFY?

  58.   muhammed on October 31st, 2011          Reply

    On Our production we have SharePoint 2007 version 12.0.0.6421(which means SharePoint service pack 2 is installed there). where on my VM I have a SharePoint 2007 version 12.0.0.6308.

    Which means we have to install following things to prepare my VM environment equitant to production for development:
    • Window 2003 server service pack 2 (SP2),
    • WSS 3.0 Service pack 2 and also WSS 3.0 Language Service pack 2
    • SharePoint 2007 service pack 2 and Sharepoint 2007 Language service pack 2.
    First I installed Windows 2003 server SP2 and after this I intalled
    • WSS 3.0 Service pack 2 and also WSS 3.0 Language Service pack 2
    • SharePoint 2007 service pack 2 and SharePoint 2007 Language service pack 2.
    and run SharePoint Products and Technologies Configuration Wizard, First I got this error message :
    “You must run setup to install new binary files for every server in your server farm. If you have multiple servers in your server farm, run setup and the configuration wizard on the other servers now, and then return to this server and click OK to continue.”
    and then I got Configuration failure message as shown below
    Failded to initiate the upgrade sequence
    An exception of type Microsoft.SharePoint.upgrade.SPIpgradeException was thrown. Additional exception information: Duplicate Id on sequence[Microsoft.SharePoint.Portal.Upgrade.FarmSequence].
    Now Central Administraiton also stopped working because of this configuration failure.

    Do I need to installed all the SharePoint 2007 updated or only WSS 3.0 Service pack 2, WSS 3.0 Language Service pack 2 and SharePoint 2007 service pack 2 and Sharepoint 2007 Language service pack 2 are enough.

  59.   xlpharmacy on December 12th, 2011          Reply

    I wonder if you have more info about share point!

Leave a Reply