Install SharePoint 2010 Service Pack 2 the right way

Install SharePoint 2010 Service Pack 2 the right way

Unless you were on vacation for the past three weeks, by now you know that SharePoint 2010 Service Pack 2 is out and ready to be installed! If you’re looking for the announcement, or download links, check out this post: SharePoint 2010 Service Pack 2 Released . This article will be focused on some questions I got from SharePointers from SharePoint-Community.Net and also from friends… How do I patch my SharePoint 2010 farm the right way? Let’s start with some SharePoint Myth Buster action!

Install SharePoint 2010 Service Pack 2 the right way by Vlad Catrinescu

Myth 1: I need to apply both SharePoint Foundation SP2 and SharePoint Server SP2

That is not true! In SharePoint 2007 and until August 2011, you had to do this, but it is not true anymore! Here is the Best Practice quotation from the official technet article:

The packaging of cumulative updates changed as of August 31, 2011. […]As a result of the new packaging, it is no longer necessary to install the SharePoint Foundation cumulative update and then  install the SharePoint Server cumulative update.

You can read the full paragraph here: http://technet.microsoft.com/en-ca/sharepoint/ff800847.aspx#LatestUpdates

Conclusion : If you have SharePoint Server 2010, you only need to install the SharePoint Server Service Pack!

Myth 2: If I have SharePoint Server 2010 in English and X Language Pack, I need to install the Service Pack 2 in English and Service pack 2 in X language.

This Myth is also BUSTED. You only need to install the SharePoint Service Pack in the language of the original installation, then install each Language Pack Service Pack in the languages deployed to the farm. For example, if the farm is installed with en-US, and you have installed the French Language Pack, simply install the SharePoint Service Pack 2 from the English download, and the French Service Pack 2 from the Language Pack download (Service Pack 2 for Microsoft 2010 Server Language Pack).

Myth 3: I need to test Service Pack 2 in my test farm before installing it in production

You NEVER install any update (Windows, CU, PU, SP, etc..) in any SharePoint Environment without testing it in a Test Farm. You have been warned!

Myth 4: Since the Service Pack 2 came out in July, and June 2013 CU came out.. in June, Service Pack 2 is the latest available build.

False! June 2013 is a post-Service Pack 2 release (though it does not require SP2). Furthermore, you can’t install June 2013 CU over Service Pack 2 due to patch detection logic errors in the June 2013 CU. Official Microsoft Recommendation? Wait for the August 2013 CU!

How to Install SharePoint 2010 Service Pack 2

Now that our Myth Busting is done, let’s get to business and see what steps we need to take to properly install Service Pack 2 on your SharePoint 2010 Farm. For the sake of the article, let’s suppose you have a super SharePoint 2010 farm with 1 APP server, and 2 Front Ends (WFE). Furthermore, you also have Office Web Apps and the French Language Pack. Here is a small diagram stolen from blog.sharepointedutech.com

1. Install SharePoint Server 2010 Service Pack 2 on all of the SharePoint servers in the farm. The installation of the binaries can be done in parallel, or sequentially.

2. Install the Office Web Apps 2010 Service Pack 2 on all of the SharePoint servers in the farm.

3. Install the French Language Pack Service Pack 2 for SharePoint 2010 on all of the SharePoint servers in the farm. When downloading Language Packs, make sure to select the appropriate language from the drop down and wait until the page appears in the desired language before clicking the Download button

PS: If you have Project Server 2010, make sure you read this post from the Microsoft Project Support Blog: http://blogs.technet.com/b/projectsupport/archive/2013/07/23/project-2010-and-project-server-2010-service-pack-2-sp2-released.aspx

4. Now that the binaries are installed on all the servers, it’s time to go to the more stressful part which is running the SharePoint 2010 Configuration Wizard. On any one of the SharePoint servers, start and run the “SharePoint 2010 Configuration Wizard” as an administrator. In the Configuration Wizard, it may ask you if you want to change anything. At this time, do not change anything, simply click next, next, and next. If you cheated in any of the previous steps, you will have an error in this step!.

5. After the Configuration Wizard is done running on the first server, run it on the next SharePoint server in the farm! Repeat Step #5 until all SharePoint servers are upgraded.

6. Time to test everything!

You are done and successfully installed SharePoint Server 2010 Service Pack 2 using the best practices from Microsoft!

I also want to give a huge thanks to Trevor Seward, SharePoint MVP,  for reviewing this post to make sure every step is done according to Microsoft’s Best Practices.

Share this post with your followers on twitter:

timthumb

Leave  a comment and don’t forget to like us on Facebook here and to follow me on Google+ here and on Twitter here  for the latest news and technical articles on SharePoint.  Also, don’t forget to check out SharePoint Community.Net for more great SharePoint Content!

No ratings yet.

Please rate this

 
Comments

My system has the Spanish and Chinese language packs – I did not specifically see those as separate downloads, it looked as if they were part of the standard language packs download, Is that something you or Trevor could clarify? (I remember feeling dumb with the original LP’s because I totally missed the language drop down box on the MS download website – so I had downloaded and installed the English language pack the first time I did it, which of course, I didn’t need!

Thanks for the post!

Hey Jack,

Here is the Spanish Language Pack Service Pack 2 update : http://www.microsoft.com/es-es/download/details.aspx?id=39675

And here is the Chinese Simplified Language Pack Service pack 2 update: http://www.microsoft.com/zh-cn/download/details.aspx?id=39675

Also.. Chinese Traditional: http://www.microsoft.com/zh-tw/download/details.aspx?id=39675

Only download the Chinese Pack you need, I did not know which one you got so gave both!

If you got any other questions, don’t hesitate!

Hi Vlad,

Its really nice article and I am following this to upgrade both Sharepoint server & office web app from sp1 to sp2.
Here my concern’s on 3rd point ,regarding the language pack upgrade:
Currently in my environment,we are having apx 9 sharepoint languages(RTM+Sp1) installed and our requirement is too update languages as well,I just want to know,do I have to download the sp2 package for all 9 language http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=3411 and upgrade it one by one.or is there any direct link that I can go in one short.

Thanks in advance.

Unfortunately nope :(. You can always just script the binary installation , just go in cmd in the exe and run something like englishlanguagepack.exe /? and you will see the install switches.

Hi Vlad!
I have Search Server Express 2010. There is sp1 for SSE, but no sp2. Some articles say that both Foundation and Server patches should be installed for SSE to update it properly. What do you think about it?
Thanks

For Search Server Express, you should be able to use the Search Server 2010 Service Pack 2 package (http://www.microsoft.com/en-us/download/details.aspx?id=39656). Since you’re using Foundation, yes I believe you will want to use Foundation SP2 + Search SP2, although I haven’t used SSE since WSSv3.

Hello,

Are you positive on the fact I need to install SP 2 LP’s for each language I have installed? I am reading the Office SP2 Language pack page and it says that the LPs are in the Server SP2 package.

http://support.microsoft.com/kb/2687462
Download the Microsoft Office Servers 2010 Language Pack Service Pack 2 package now.
Note On Microsoft Update, this service pack is included in Microsoft SharePoint Server 2010 Service Pack 2 (KB2687453).
For all other languages, click the following download links: Which list 10 languages

George, for all LPs, you do need to install the respective SP2 LP (or the general SP2 LP). If the LPs were included in the base package, the base package should be 1GB+. Note that it indicates that the SP2 LP general package is only included on Microsoft Update (e.g. Control Panel -> Windows Updates).

Hi, are there any prerequisites (CUs) that must be installed before upgrading to SP2?
Our farm has a very old CU installed and is running rather smoothly. But it’s time for an upgrade hence the question.
Or can I just go ahead with SP2 installation and testing?

Hello Francois,

Yes there are no prerequisite to install the SP2. You can install it over RTM!

Thanks for clearing that up 🙂

Sorry but why do we need to install the French Language Pack? Am I being incredibly stupid here?

Hey!

You don’t have to install the French Language pack if you don’t have it on your farm! I gave an example of a farm that had it, so we had to install it!

You only need to install the Language Packs if you need them 🙂

Is there a de-installation procedure?

There is no uninstall procedure for a SharePoint Update… make sure you take your Virtual machine backups if you want to rollback!

Hi
I am trying to update with sp1 +sep 13 in my farm .is it supported? Actually i am getting error during wizard running in step 3. Configuration data base null exception and timer job failed . please suggest me which steps i need to follow for success.

There is no Cumulative Update in September 2013! You should be able to install the August 2013 SharePoint 2010 Cumulative Update directly over SP1. “To install this hotfix, you must have either SharePoint Server 2010 Service Pack 1 (SP1) or Service Pack 2 (SP2) installed. For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:”

I’ve just been testing the SP2 installation on our development environment and I the installation seems to have gone off and done a complete upgrade without having the opportunity to install the binaries and run the config wizard. The only thing I can assume is because it’s a single server farm it “knows best” or has MS changed something in the installation process.

Hi
What is today situation about the installation of the SP2 and June CU?
As I saw they revisited the June patch. Should I install now SP2 and after that the revisited June update?

Hello, I am not 100% sure about the June 2013, however I suggest you install SP2 and then August 2013. That should fix all the problems!

Hi Vlad
Are you 100% sure that august CU contains the patch from jun?

CU contains each time another CU? This is not the thing that I am 100 % sure 🙂

Yes, Cumulative Updates are Cumulative :). (For example August 2013 CU contains June 2013 CU)

It appears that August 2013 CU does not contain June 2013 CU. Check this post: http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=430

Would be nice to know if this is the case?

/A

Hello,

That’s just a bug included in both version. August 2013 CU even includes September 2013 PU. Read this: http://blogs.technet.com/b/stefan_gossner/archive/2013/10/08/sharepoint-2010-september-2013-pu-and-august-2013-cu.aspx

I hoped that here I can find info how to create language pack for languages that Microsoft don’t support.
Can you please give me suggestion how to create custom language pack?
I need to create Albanian language pack.

Best regards,
Thank in advance.

Hello, I cannot give information on stuff that’s not supported by Microsoft:(. Sorry!

I’ve got a Configuration Failed result. Installation of SP2 was successfully possible on all WFEs and APP.
During step 9 of 10 after 50% the SharePoint Product Wizard fails.
Do you have a hint on the following errors:
A) ERR Could not start Service ProfileSynchronizationServiceInstance. Setting the service instance object to offline.
B) ERR The exclusive inplace upgrader timer job failed.
To date I was unable to find help though google.
Much appreciate.

Can you check if SP_Farm is part of the Local Admin group? It might need to be there since it might reprovision USPS SA.

I’ve already checked that. SP_Farm has local admin rights. I also started the SP Product Wizard with SP_Farm. I also gave SP_Farm temporary highest sysadmin privileges on SQL server. But still failed.
When I check the version with PowerShell (get-spfarm).buildversion it returns: 14.0.7015.1000 but I don’t know whether everything is working fine. I can’t believe it.

Hi, While installing SP2, i am getting the following error ” Error occurred while running Detection”.
Please advise the troubleshooting steps.

Hey, Can you give me more details? Check the MSI logs, they should be in %TMP% of the user running the executable. I *think* part of the detection process happens there as well. Also check the ULS/setup logs in the 14\LOGS folder, of course

Why is it required to install Sharepoint bits on a SQL Server box ?

It’s not required to install SP bits on your SQL Server… you can have them completely apart. Only reason I see is SSRS.

Hi! How to install SP2 in the Sharepoint Foundation 2010? Thank you

You download and install SharePoint 2010 Foundation SP2

No previous requirements? only I download and install sp2?

Can we run the configuration wizard parallely on different SharePoint server in the farm after patch installtion on both the server.

You can install the binaries parallel, however I recommend running the config wizard one at a time!

Thnkas for taking the time to post. It’s lifted the level of debate

Hi – new to SP installs. What state does SharePoint need to be in before running the SP – any services need to be stopped or does it do all that itself? Thanks – useful page!

SharePoint 2010 will do all that for you! Don’t have to stop anything!

Brill, many thanks.

This feels like a numpty question, but I’m doing SP2 now and it asks if I want to reboot now to complete the installation (stage 1 above). Should I? Or should the reboot be left until all language packs etc have been installed, too?

Hmmm, not sure why it prompted me to reboot – just on one server (the first). The others haven’t prompted me.

It does that sometimes depending on some service applications. I bet it asked you this on the “app server” that hosts the central admin! It happens sometimes, so nothing to worry about!

Reboot as soon as it asks you to, however you will have downtime on this server!

We have Project Server/Sharepoint 2010 installed. Our support team just installed SP2 for Sharepoint instead of the combo package for Project Server and SharePoint SERVER. I tried to install it (KB2687452) and am now getting errors in the config wizard saying the Foundation Core and related updates, along wtih both SharePoint Server and Project Server, are missing on the web server. I know you cannot uninstall service packs. Is there any option short of restoring the entire farm from before they installed the wrong SP2?

JU, run Get-SPProduct -Local on each server, then re-run the Config Wizard.

After installation you may see some alerts (specificallly if you run SBS) and you need to run PSConfig to finish the upgrade.
Refer to this blog post; http://blogs.technet.com/b/sbs/archive/2011/05/24/you-must-manually-run-psconfig-after-installing-sharepoint-2010-patches.aspx

I’m have SP 2010 Server at SP1 and CU from 2012. I would like to update to SP2 and December CU from 2013. Would I do the SP2 first or Dec 2013 CU first?

Also, I don’t understand the versioning with SP. If I stay on SP1 and install the Dec 2013 CU, the version number will show higher than what it would say if I had SP2. It’s kind of confusing, so I can’t look at a version level and know for sure if SP2 is on or not because I can be at a higher version level with SP1 and the newest CU.

Hey,

I would go to SP2 and then to DEC 2013 CU. In theory, the DEC 2013 CU includes all the updates in SP2, so that’s why version number is higher. However, I usually always go to latest SP before CU just for safety reasons :).

Do you run the SharePoint Products and Configuration Wizard after you install SP2 and the Dec Cumulative update?

After every SP Update, you need to run the Config Wizard!

Hello. Do I need to reboot the servers after installing binaries and running the configuration wizard? Thanks.

Hello, you might be asked to reboot the SharePoint server. If Yes, the installer will ask you before running the Config Wizzard usually! If it doesn’t ask you, you don’t need to!

Thanks mate. Unfortunately I’m still getting an Upgrade Failure “An exception of type Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException was thrown. Additional exception information: The upgradecommand is invalid or a failure has been encountered. Failed to upgrade SharePoint Products.”

Finally got config wizard to complete – input ‘net start SPTimerV4’ repeatedly… Seems to have worked…

Hi, me again. I’m about to upgrade our production farm and for the purposes of getting the change signed off need to know whether sites will still be available. Is it just during psconfig that the farm becomes unavailable to users? Thanks

Hello James,

Most of the times sites will still be available during the installation, but you will have downtime during PSConfig. Some rare times (usually the app server) might require a reboot after the binaries installation (it will ask you to). I still recommend doing it in the off hours to avoid stress!

Thanks,

Hi,

Does psconfig still need to be run with the installation of service pack 2? I have not seen anything staing it does after the installation. Please advise

thanks!

You need to run either psconfig (powershell) or the Configuration Wizzard!

Hi,

I have 1 Sharepoint 2010 server that is RTM. Im going to install service pack 2 directly, after that is done, do i need to do anything is PSConfig, or is everything done with the service pack installation? Im a bit confused with the people having issues and having to use PSConfig. From your walk through here, it sounds like i dont have too and all will be fine, but wanna make sure.

thanks!

PSConfig is the powershell equivalent to the SharePoint 2010 Configuration Wizard. You can run any of them, but I prefer to run the Configuration Wizard!

Hi,
I plan to install Sharepoint Foundation 2010 SP2 and CU December 13.
After installation of SP2 – do you have to run the configuration wizard or can one just install SP2 and CU Dec13 and then only run the configuration wizard once?
Thanks!

You can run it only once after you finish installing all binaries (Sp2 + Dec 2013 CU) !

Hello,
Do I need to follow step 2 if client machines show Office SP2 build version? Or am I completely off base in my understanding in what that update is for?
Thanks

This update is for the SharePoint Server not Office client machines!

Hello–
Do you install the latest CU before installing the Office Web Apps 2010 SP2?
Please check if this order is correct: SP2–>Feb 2014 CU–>Office Web Apps 2010 SP2–>Configuration Wizard.

Thanks!

It is correct! However why not patching OWA to Feb 2014 cu at the same time?

Hi in our org enterprise search is configure in sharepoint 2010

production environment has

2 application servers

2 webfront end servers

2 index servers

1 databae server
here i want to upgrade to service pack 2 now it is service pack 1
so there is any sharepoint server search service pack 2 is available to install
so in my form how i apply service pack 2

Search is actually SharePoint.. so you only patch SharePoint!

I encountered the same error as RoyMcCaw : Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException was thrown. Additional exception information: The upgradecommand is invalid or a failure has been encountered. Failed to upgrade SharePoint Products

Nothing really useful in the log so I tried restarting the wizard. I had more options than the first time and it succeded in 1-2mn. I have the right version in both Powershell and the CA, but in the “check upgrade status” in the CA, I see the first one that failed, I can’t see the second one that succeded … I’m not sure everything is alright, what can I do ?

Check the PS Config logs! Sometimes it’s really messy and there is no “1 fix for all farms” unforuntately :(.

Hi Vlad,

I am about to upgrade a SP farm from SP1 + August ’11 CU to SP2 + August ’13.

This will be my first patch and I am wondering if I need to install the Office Web Apps SP2 separately or not. How would I figure that out?

If you have Office Web Apps you will need to do the following:
> Install SharePoint Sp2
> Install Office Web Apps SP2
> Install SharePoint August 2013 CU
> Install Office Web Apps August 2013 CU
> Run the config wizzard!

I am still a bit confused…is Foundation Server for SP2 included in the SharePoint 2010 SP2 install. I thought that any service pack for Foundation Server would be included in the SharePoint 2010 SP2 service pack at this point.

Yes! You only need to install server and not foundation + Server

Hi Vlad,

Thanks for the repky. I had a second question. Do you recommend or is there any way to keep users out of the SharePoint sites during the upgrade? Can there be a potential problem when users have http sessions open as the content databases are being upgraded. I know there is a quiesce command that can lock users out but I do not know if that will cause an upgrade failure when the configuration wizard is run. Thanks!

Usually I do it in maintenance time when no one should acces it, but if you really want to be sure, just shut down the application pool and they wont be able to access the web application!

Hi Vlad, I’m planning on patching my SharePoint server 2010 farm up to the August 2013 CU.
I farm is currently st SP1 June 2012 CU with OWA SP1.
AS you advised, I was plannning on deploying SP 2010 server SP2, then OWA SP2, then August 2013 CU. The problem I’m having is I cannot find an August 2013 CU for Office Web Apps. Is there one out there? I’ve seen blogs that says that OWA CU are included in Office CU but when I look at the August 2013 CU for office 2010 found here (http://technet.microsoft.com/en-us/office/ee748587.aspx), I don’t see any mention of OWA.
Any idea?

Thanks.

Raoul M.

Hey,

I can’t find it either, but you can try the September 2013 PU which should be more tested then the August 2013 CU!

in my test environment (which mirror’s Production) I am able to install the svrprjsp2010 (I am running project server 2010) and it installs fine, when I try and run the configuration wizard I get a failure stating I don’t have to OWA’s installed. They were never installed to begin with. I tried running the OWA sp2 and I get the “this product is not installed” error.
At this point I am just spinning my wheel’s. Any suggestions? My last CU that was installed was Dec 2012.

Hi im trying to upgrade DEV server to sharepoint 2010 SP2 and im stack with below error when running psconfig -cmd upgrade -inplace b2b -wait -force .
09/03/2014 12:15:28 9 ERR Configuration of SharePoint Products failed. Configuration must be performed in order for this product to operate properly. To diagnose the problem, review the extended error information located at C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\LOGS\PSCDiagnostics_9_3_2014_12_15_6_400_1720718873.log, fix the problem, and run this configuration wizard again

Server tropology : Single server fame
Configuration database version: 14.0.6137.5000

Hey, Can you post your logs on http://www.sharepoint-community.net in a discussion? will be able to help you more!

Thanks!

We have a farm where it is running SP1 with Feb 2012 CU. We have a requirement to upgrade it to SP2 with April 2014 Patches…Could you please help here to overcome the issues while installation.

Hey, I am not sure how I can help you more than the article :)?

Hey Vlad,
After applying SP2 for SharePoint 2010 server, do you recommend applying the latest CU for SharePoint 2010 server which according to the following link is September 2014, 14.0.7132.5000

http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=224

Thanks!

Hey,

Cumulative Updates only fix specific issues! If SP2 is stable for you and you don’t have any issues that are fixed between SP2 and September 2014, I wouldn’t update!

hello Vlad,
updating 2010 Foundation – why is the SP2 download only 43MB when Foundation CU’s after SP1 (e.g. august, october, december 2011, february 2012 are 90MB, 118MB, 33MB, 144MB) were larger?
It feels like we may be missing something if it should be cummulative. SP2010 SP2 weighs in at 437MB.
I used the links from http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=224
thank you.

I did everything this post but PCW asked me to create new site but i choose to Skip this step and upgrade finished without error. Any explanation re this
Thanks

once the SP Config Wizzard finishes, it opens central admin I always click “no thanks I will configure everything myself”

I have Project Server 2010/SharePoint Server 2010/Office Webs Apps 2010. From your guide, I’m assuming all I need to do, is download Project Server 2010 Sp2 and OWA apps sp2 to all sharepoint servers and run configuration wizard server by server. Do I need any CU Updates on top of this? Or will I be good to go with just the two Service pack 2?

if you want only to go to SP2, you don’t need any CU. You install the SharePoint Sp2, Project SP2 and then the Office Web Apps Sp2 to all sharepoint servers, then you run config wizzard on each 1 at a time.

Cliff Fernandes

Hello Vlad,
Does the SP2 install files require Internet access? We are setting an test environment where the servers will not have access to the Internet?
Thanks, Cliff

Shouldn’t require internet access. But you need to get all patches on the servers locally :).

Hi Vlad,

First of all, thanks for your clear article on how to update your SharePoint form to SP2!

I’m going to perform the SP2 update on a small farm.
I’ve got the following question:

Due to Microsoft update I get the following warning on my SharePoint farm:

Warning: The farm servers do not currently have the same product and patch level as each other. Upgrade should not be run on any farm server until all farm servers have the same set of required products and patches installed.

The following products have been updated:

Update for 2010 Microsoft Business Productivity Servers (KB2899582) 64-Bit Edition 14.0.7109.5000 Missing/Required
Update for Microsoft Web Applications (KB2910901) 64-Bit Edition 14.0.7109.5000 Missing/Required
Update for 2010 Microsoft Business Productivity Servers (KB2899582) 64-Bit Edition 14.0.7109.5000 Missing/Required

All the other products have version 14.0.6029.1000 Installed.
Can I update the farm with SP2 with these warnings?

Thanks,

Erik

Hi,

I have a similar issue as Erik. I successfully installed SP2 and upgraded in my farm (1 APP, 2 WFE, 1 DB), but now I am looking at installing the CU’s to get current and there are certain patches being reported on the APP server as missing from Service Pack 2. I have tried to kick off the timer job Get-SPProduct -local but they are still reporting as missing. Any recommendations?

I have Arabic installed on my farm but don’t see it in the SP2 Language Pack download list. Is there not an upgrade for Arabic for SP2? And if not will this cause an issue with the upgrade? Or am I just not finding it?

You might have to open a ticket with MS on that one. I can’t seem to find it either :(.

Leave a Reply