Alright, everyone else has a checklist — time for mine :). Here’s how we’re installing SCCM 2012 SP1. Once again, this is based off of my internal documentation, so it’s not as polished as it really should be for the open web. I’ve been putting off blogging for so long — it’s time to just get something out there and see if it helps anyone.
- Configure Site Backups
- Spin Up a SQL Server Test VM
- Test the Database Upgrade
- Disable Site Maintenance Task
- Backup Boot Image Customizations
- Upgrade from WAIK to ADK
- Install WSUS Hotfix
- Run the Prereq Checker
- Run the SP1 Install
You can download an actual excel checklist from the John Puskar Github Repo.
This is going to be a long post…
Configure Site Backups
- Administration -> Site Configuration -> Sites -> CAS -> Settings -> Site Maintenance
- Backup Site Server -> Edit
- Enable this task
- Set paths -> Local Drive -> F:\Backups
- Start time — 5mins from now. Latest start time -> 1hr after start time.
- OK to save.
- Wait and get the backup.
Spin Up a SQL Server Test VM
- 80GB Free space
- Install MS SQL — same version as the one which produced the database backup.
- Install MS SQL Server 2012 Native Client. Download from here. You have to click ‘download’, then ignore the text file that gets downloaded and scroll to the middle of the download confirmation page. Microsoft® SQL Server® 2012 Feature Pack
Test the Database Upgrade
- Login to the test server using a domain account that has local administrator and SQL sysadmin privileges.
- Copy the SCCM Site Backup folder from SCCM server to test server.
- Open SQL Server Management Studio.
- Right-click the SQL Server and choose ‘attach’.
- Navigate to the backup folder and select the MDF file found in the site server backup folder.
- Click OK to attach the db.
- In SQL Server Management Studio, navigate to Security -> Logins.
- Right-click the account or group which represents your current login and choose ‘properties’.
- Choose ‘User Mapping’ from the left-pane, then select your attached site server database.
- Check the box next to the site database backup in the ‘map’ column.
- Check the ‘db_owner’ box in the bottom pane.
- Click OK to save changes.
- Open a command prompt as administrator and navigate to .\sccm2012sp1\smssetup\bin\x64.
- Run setup.exe /testdbupgrade <dbname> (ex: cm_cas)
- Prerequisite checker should pass.
- Click ‘next’ to attempt the upgrade.
- Watch task manager for the sqlservr.exe process’ CPU usage. It will spike for 20mins or more.
- When the sqlservr.exe process seems to be idle, open the file C:\configMgrSetup.log. It should read ‘Successfully upgraded the SCCM database’.
Disable Site Maintenance Task
- Open SCCM Console on the CAS and navigate to Administration -> Site Configuration > Sites.
- Right-click the CAS site and choose ‘Site Maintenance’.
- Select the task ‘Delete Aged Client Operations’.
- Click the ‘disable’ button and confirm that the column labeled ‘Enabled’ reads ‘No’ next to the task.
- Click ‘OK’ to save changes.
Backup Boot Image Customizations
Run the following commands and confirm that the files are actually copied.
MKDIR C:\backups MKDIR C:\backups\bootimages MKDIR C:\backups\bootimages\Extra IF EXIST "C:\Program Files\Microsoft Configuration Manager\OSD\Extra" XCOPY /e /y "C:\Program Files\Microsoft Configuration Manager\OSD\Extra" C:\backups\bootimages\extra\ XCOPY /y "C:\Program Files\Microsoft Configuration Manager\bin\x64\osdinjection.xml" C:\backups\bootimages\
Upgrade from WAIK to ADK
- Obtain the ADK Downloader, and download the full ADK installer. The downloader is available here: Windows Assessment and Deployment Kit (ADK) for Windows 8
- Uninstall WAIK from control panel.
- Run the ADK installer.
- Choose to install the following features
- Deployment Tools
- Windows Preinstallation Environment (Windows PE)
- User State Migration Tool (USMT)
Install WSUS Hotfix
Download the following hotfix and install.
Run the Prereq Checker
- Navigate to .\smssetup\bin\x64 and double-click ‘prereqchk.exe’.
- You will probable see a SQL Server process memory allocation error, but that should be the only issue.
Run the SP1 Install
- Run the following command:
cmd /c mkdir C:\SCCMDownloads-SP1
- Navigate to .\smssetup\bin\x64 and double-click ‘setup.exe’.
- On the ‘Getting Started’ screen, choose to ‘Upgrade this Configuration Manager site’
- On the ‘Product Key’ screen, enter the licensing information and click ‘next’.
- On the ‘Microsoft Software License Terms’ screen, choose ‘I accept’ and click ‘next’.
- On the ‘Prerequisite Licenses’ screen, accept all the license terms and click ‘next’.
- On the ‘Prerequisite Downloads’ screen, choose the download required files to C:\SCCMDownloads-SP1 and click ‘next’.
- On the ‘Server Language Selection’ screen, click ‘Next’.
- On the ‘Client Language Selection’ screen, click ‘Next’.
- On the ‘Settings Summary’ screen, confirm that the box reads ‘Setup Type – Upgrade’, then click ‘Next’.
- On the ‘Prerequisite Check’ screen, click ‘Begin Install’.
- Complete the wizard.
One thing I noticed is that database replication doesn’t work well until all the site servers are upgraded. Good luck!