Step-by-Step SCCM 2012 R2 SP1 Upgrade Guide

Benoit LecoursSCCM165 Comments

Microsoft has recently announced the release of SCCM 2012 SP2 and SCCM 2012 R2 SP1. Before performing an SCCM 2012 R2 SP1 upgrade, we recommend that you read carefully all the available resources and carefully plan the upgrade process throughout your SCCM 2012 R2 hierarchy. The good news is that our SCCM 2012 R2 SP1 Upgrade Guide will list everything you need to know before applying this major upgrade to your existing SCCM 2012 installation. We’ve got you covered !

What’s new

The main reason you’ll want to upgrade to SCCM 2012 R2 SP1 is probably for Windows 10 support. No plan for Windows 10 deployment in your organisation? There’s interesting new features and a lots of bug fixes (thousands, which are not fully documented) in this release that are worth it. Do I still need to perform the SCCM 2012 R2 SP1 upgrade? See the full list of features on this Technet Article to figure it out.

Naming Confusion

Following the announcement, the community was confused on how to apply this Service Pack because Microsoft decide to release it under one binary even if there’s 3 possible “version” of SCCM 2012. (SCCM 2012 RTM, SCCM 2012 SP1, SCCM 2012 R2)

  • If you’re running SCCM 2012 SP1 (non-R2) the upgrade process will bring your site to SCCM 2012 SP2
  • If you want to upgrade to SCCM 2012 R2 SP1 afterward, you’ll need to run another executable which will enable the R2 features
  • If you’re already running SCCM 2012 R2, the upgrade process will bring your site to SCCM 2012 R2 SP1

Fellow MVP Jason Sandys explain all the upgrade options in an excellent post. The key is really to understand the upgrade process by identifying your actual version and the desired final version.

Prerequisites

Our post focus on what needs to be done to upgrade a stand-alone SCCM 2012 R2 Primary Site to SCCM R2 SP1. This post is not covering all the requirements and checklist steps needed if you’re running SCCM 2012 SP1 (non-R2).

If you have a hierarchy with a Central Administration Site and multiple Primary Site, start with the top of the hierarchy (CAS) and go down, upgrading all Primary Sites and Secondary Sites.

If you’re already running SCCM 2012 R2, the upgrade process won’t do a site reset :

From Technet: When you run this upgrade, it enables additional capabilities throughout your hierarchy. Because this upgrade enables additional functionality and does not upgrade features and components, there are no considerations or changes to settings or site system roles as there is when you install a new service pack.

Database Replication

If you have a database replica for management point, disable Database replication. If you don’t use this function, skip this step and go to the Backup and Testupgrade section

  • Open the SCCM Console, browse to Administration / Site Configuration /Servers and Site System Roles
  • Select the Site System that hosts the management point that uses the database replica
  • Right click Management point and select Properties

sccm 2012 r2 sp1 upgrade

  • On the Management Point Database tab, select Use the site database and click Ok

sccm 2012 r2 sp1 upgrade

  • Connect to the SQL server hosting the replica databases
  • Open SQL Management Studio
  • Go to  Replication / Local subscription
  • Right click the replica and select Delete. Select Yes to the warning prompt

sccm 2012 r2 sp1 upgrade

  • Right click the publisher database and select Delete. Select Close existing connections and click OK
  • Connect to the SQL server hosting the site database
  • Open SQL Management Studio
  • Go to Replication and select Disable Publishing and Distribution

sccm 2012 r2 sp1 upgrade

  • On the next screen, click Next
  • Select Yes, disable publishing on this server and click Next, Next, Next
  • Click Finish

Backup and TestUpgrade

  • Before upgrading, perform a backup of your SCCM database.
  • It is recommended to test your CM database before the upgrade.  Detailed procedure is available on Technet, here’s the resumed version :
    • Backup your site databse
    • Restore it on a SQL server running the same version as your SCCM SQL instance
    • On the SQL server, run the SCCM setup command line using the Testdbupgrade switch
    • Open the log file on C:\ConfigMgrSetup.log
    • If the process is successful, you can delete the database copy
    • If you have errors, resolve them on your SCCM server, do a new backup and restart this procedure

sccm 2012 r2 sp1 upgrade

After you successfully upgrade a copy of the site database, proceed with the “real” upgrade.

Running Console

Close all running console on the server. Check also if remotely logged users are running the console in their sessions. The setup won’t check that and you’ll endup having an error in the installation log at the end of the process.

ERROR: Configuration Manager console uninstallation failed. Check log file ConfigMgrAdminUISetup.log.

4410 (98)

Installation

The installation process is not like a CU installation. The user experience is like a new SCCM installation.

  • Download the necessary files. You can download the file from the Technet Evaluation Center. The non-eval files will be available on the Microsoft Volume Licensing Site on May 27th. You can install the evalutation version on a non-eval site without problem, it won’t “convert” your site to an evaluation version.
  • You’ll notice that there’s 2 available SP2 executables.
    • Refer to the table in Jason Sandys post to understand which one to run. (Depending of your actual site version and the desired final version)

sccm 2012 r2 sp1 upgrade

  • In our case, the site is already R2 so we extract the SC2012_SP2_Configmgr_SCEP.exe to a folder and execute Splash.hta
  • On the main menu, select Install

sccm 2012 r2 sp1 upgrade

  • On the Before You Begin screen, click Next

sccm 2012 r2 sp1 upgrade

  • On the Getting Started screen, select Upgrade this Configuration Manager site

sccm 2012 r2 sp1 upgrade

  • On the Microsoft Software License Terms, check I accept these license terms and click Next

sccm 2012 r2 sp1 upgrade

  • On the Prerequisite Licenses, check all 3 boxes and click Next

sccm 2012 r2 sp1 upgrade

  • On the Prerequisite Downloads screen, specify a location to download the prerequisite files. This folder can be deleted after the upgrade process

sccm 2012 r2 sp1 upgrade

  • The prerequisite files are downloading

sccm 2012 r2 sp1 upgrade

  • On the Server Language Selection screen, select the language you want to display in the SCCM Console and Reports

sccm 2012 r2 sp1 upgrade

  • On the Settings Summary screen, you will see that you are performing an Upgrade

sccm 2012 r2 sp1 upgrade

  • The Prerequisite Check is running

sccm 2012 r2 sp1 upgrade

  • You should have no errors since your site is already installed and running
  • Wait for Prerequisite checking has completed and click on Begin Install

sccm 2012 r2 sp1 upgrade

  • The installation is in progress. The installation will run for about 30 to 45 minutes depending of your server specifications
  • You can follow the progress by clicking the View Log button or open the ConfigMgrSetup.log file on the C:\ drive

sccm 2012 r2 sp1 upgrade

  • Wait for Core setup has completed and close the wizard

sccm 2012 r2 sp1 upgrade

Verification

Once the setup has completed, there’s a couple of check that you can make to be sure the upgrade process was successful.

  • C:\ConfigMgrSetup.log  – Display detailed installation steps

sccm 2012 r2 sp1 upgrade

Console

  • Open the SCCM Console and click on the upper left corner on the blue arrow and select About Configuration Manager
  • The Console has been upgraded to SP1
    • A new addition is the Site version which was not available on this screen before

sccm 2012 r2 sp1 upgrade

Site

  • Go to Administration / Site Configuration / Sites
  • Right-click your site and select Properties
  • The Site Version and Build Numbers has been upgraded to 5.00.8239.1000

sccm 2012 r2 sp1 upgrade

Clients

The site server client version will be upgraded to 5.00.8239.1000. A full list of client version is available on this post.

sccm 2012 r2 sp1 upgrade

Boot Image

  • Go to Software Library / Operating Systems / Boot Images
  • You’ll notice that the Boot Images has been automatically upgraded on your distribution points

sccm 2012 r2 sp1 upgrade

Packages

  • Go to Software Library / Application Management / Packages
  • The Configuration Manager Client Package has been automatically upgraded on your distribution points

sccm 2012 r2 sp1 upgrade

Database Replication

Enable the database replicas for Management Points,  if it was configured before the upgrade.

Updating the Clients and Consoles

Once your site is upgraded, you need to upgrade the clients and console to SP1.

Console

You can manually upgrade by browsing to .\ConfigMgrInstallationFolder\tools\ConsoleSetup and execute ConsoleSetup.exe on each computer running the console.

We suggest to create a package or application pointing on the same directory and deploy it using a collection.

All clients with the SCCM console installed

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = 'System Center 2012 R2 Configuration Manager Console'

Clients

To upgrade the clients, you have various options.

Automatic Client Upgrade

Using the Automatic Client Upgrade option, your client will be upgraded automatically within x days using the value specified

  • Go to Administration / Site Configuration / Sites
  • Click on the Hierarchy Settings button on the top ribbon
  • Check the Upgrade client automatically when new client updates are available
  • Select the desired number of days you want your upgrade to be run
  • A schedule task will be created on the clients and run within the specified number of days

sccm 2012 r2 sp1 upgrade

Client Push

Create manual collection and use the client push function to deploy your clients. This method gives you more control on the group of computer you are upgrading.

sccm 2012 r2 sp1 upgrade

I like to create a collection that targets clients without the latest SCCM 2012 R2 SP1 version. I use it to monitor which client haven’t been upgraded yet.

Here’s the query to achieve this: (You can also refer to our Set of Operational Collection Powershell Script which contain this query)

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.ClientVersion != '5.00.8239.1000'

Report

You can run our Client Health Check custom report to track your client versions.

Additional reference

Microsoft SCCM 2012 R2 SP1 FAQ

 

Happy updating ! 🙂

sccm 2012 r2 sp1 upgrade

165 Comments on “Step-by-Step SCCM 2012 R2 SP1 Upgrade Guide”

  1. I gotta say from many different sites for SSCM you can get a quick step by step documentation, but you have basically convert this into baby steps literally speaking ?? Dude you rock!

  2. Hi Great tutorial!
    I did the install with no problem in my lab. however, when I tried to do this in production I’m getting an error right after I click on next on the Before you Begin window. it says “The SELECT permission was denied on the object ‘Setupinfo’ database” from what I’ve read its because I didnt run this with the original installer account.
    is there a way of finding out what account installed sccm the first time? I’ve inherited the system from a previous sys admin.

    THANK YOU

  3. Pingback: Sccm 2012 User Guide | Chornsovanareach

  4. First off, thanks for a great post for upgrading sccm 2012 r2 to 2012 r2 sp1
    I have a primary sccm 2012 R2 server, a separate SQL 2012 server, 2 secondary site servers, 6 DP servers, and 3 WSUS servers. All of these are connected by fast connections. Besides making a back up the database, taking vm snapshots of the primary server, database server, and secondary servers, do I need to make a backup of the wsus servers? wsus 1 pulls down updates from MS and replicates to wsus 2 and wsus 3. Is the wsus sql express database effected by the upgrade? Do I need to back this DB up too? Is a reboot required on any of these servers, during the reboot process? If so, what is the order to shutdown the servers and bring them up? Sorry for all of the questions, a lot riding on this upgrade.
    Thanks so much,
    Mark

  5. Hi All,
    Can anyone tell me where to run the query to create the Non R2 SP1 collection? I tried to copy/paste the query in the query statement properties but its got syntax errors, I also tried to run it in powershell with the same syntax errors. Can you please advise? THank you

    1. Hi Manueles,

      I probably do it in amateur style but nevertheless I managed to adapt this query. Here is it:

      select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.ClientVersion != ‘5.00.8239.1000’

      Look at it carefully and you will see that I removed all this stuff like and all the other parts within . Then it became usable and perfectly working. Copy and paste it when create a query in Configuration Manager console.

  6. Hi Benoit Lecours

    Our system was very slow when installing applications from Task sequences. To finish a Task sequence, we have spent for 10 hours. Our task sequences included tasks : format disk, apply os, windows settings, network settings, device drivers, install power point, active office, active windows….ect…

    We saw Install Power point take for 5 hours to finish. We didn’t know how to solve the issue.
    We updated to SCCM 2012 R2 SP1 CU3 but didn’t solve the issue.

    Hope to receive help from you.

    Thanks and Best Regards,

    Quang Trieu Minh

  7. Hi everybody,

    i have upgraded to SCCM 2012 R2 SP1 from SCCM 2012 R2. However had a error fail update to boot image (x86 and x64) and I repaired boot image (https://www.niallbrady.com/2013/03/20/pxe-boot-failure-after-upgrading-to-system-center-2012-configuration-manager-service-pack-1/). Then my system was good for now.
    The reason which I decided to upgrade was slow downloading when clients were downloading from software center. I didn’t know slow downloading will be resolved or not ?

    Thanks and Best Regards,

    Quang Trieu

  8. We are using a remote SQL 2008 R2 for our SCCM 2012 R2 environment. I’ve upgraded the primary site successfully (and it has pushed out the client updates, etc.). Thing is, our remote SQL server has the following SCCM roles installed (site system, site database, component server and reporting server). When I try to install CU3 on the remote SQL server, it tells me that SCCM is not installed. Do I need to install CU3 on the remote SQL server that hosts the SCCM database?

    Thanks

    1. Hi everybody,

      i have upgraded to SCCM 2012 R2 SP1 from SCCM 2012 R2. However had a error fail update to boot image (x86 and x64) and I repaired boot image (https://www.niallbrady.com/2013/03/20/pxe-boot-failure-after-upgrading-to-system-center-2012-configuration-manager-service-pack-1/). Then my system was good for now.
      The reason which I decided to upgrade was slow downloading when clients were downloading from software center. I didn’t know slow downloading will be resolved or not ?

      Thanks and Best Regards,

      Quang Trieu

      1. Hi Benoit Lecours

        Our system was very slow when installing applications from Task sequences. To finish a Task sequence, we have spent for 10 hours. Our task sequences included tasks : format disk, apply os, windows settings, network settings, device drivers, install power point, active office, active windows….ect…

        We saw Install Power point take for 5 hours to finish. We didn’t know how to solve the issue.
        We updated to SCCM 2012 R2 SP1 CU3 but didn’t solve the issue.

        Hope to receive help from you.

        Thanks and Best Regards,

        Quang Trieu Minh

  9. thanks in advance for your response !

    I’ve install sp1 on my 2012 R2 environment starting with our primary site. When i went to install it on a secondary through the console, it ran the prerequisite checker and failed. It still says in the state “upgrade” but if you look at the installation status it clearly says failed. There is no Option to click upgrade again to im assuming start the prerequsite check again. I had an old version of sql express 2008r2 sp1 cu4 on there which didnt mean requirements. Since i’ve installed sql 2012 cu2. How can i start it again?

    Thanks!

  10. Hello, I run the update without problem.
    Client version is 5.00.8239.1301, but I have the problem now with the Remote Tools Agent, it is Disabled.
    I check the client settings in SCCM and “Enable Remote Control on clients” is Enabled.
    Any Idea.

  11. Hoping you still check this….

    Our Primary site is running SQL 2008 R2 for the SQL Server. I was wondering if this would cause any issues during the upgrade? Currently we are at SCCM 2012 R2 RTM, and want to move to R2 SP1 (whatever the current CU is). I saw some mention of SQL Server 2012 Express so that’s why this concerned me a bit. Thanks in advance!

      1. We’re on version 10.52.4000.0 which I believe, after researching SQL versioning is 2008 R2 SP2. So yay. I’m a newb to updating, but will the update process still work w/o issue? It won’t try and install 2012 express and mount our DB in that will it?

Leave a Reply