Prajwal Desai

SCCM | ConfigMgr | Intune | Windows 11 | Azure

  • Home
  • Cloud
    • Autopilot
    • Azure
    • Endpoint Analytics
    • Intune
    • PowerShell
    • Teams
    • Windows 365
  • Microsoft
    • Active Directory
    • Group Policy
    • SCCM
    • SCOM
    • Windows 10
    • Windows 11
    • Windows Server
    • WSUS
  • Software
  • Forums
  • Newsletter
  • Contact
Notification Show More
Latest News
Fix Windows Autopilot Reset Error 0x80070032
Fix Windows Autopilot Reset Error 0x80070032
Autopilot Intune
Windows activation error 0xc004c020
Fix: Windows Activation Error 0xC004C020 with 2 Easy Methods
Windows 11 Windows 10
Find the Package ID of SCCM Application
3 Best Ways to Find the Package ID of SCCM Application
SCCM
SCCM Updates Install Error 0x800b0109 0x8024b303
Fix: SCCM Updates Install Error 0x800b0109 | 0x8024b303
SCCM
Disable Windows Hello for Business using Intune ftimg
Disable Windows Hello for Business using Intune – Comprehensive Guide
Intune Autopilot
Aa

Prajwal Desai

SCCM | ConfigMgr | Intune | Windows 11 | Azure

Aa
Search
  • Home
  • Cloud
    • Autopilot
    • Azure
    • Endpoint Analytics
    • Intune
    • PowerShell
    • Teams
    • Windows 365
  • Microsoft
    • Active Directory
    • Group Policy
    • SCCM
    • SCOM
    • Windows 10
    • Windows 11
    • Windows Server
    • WSUS
  • Software
  • Forums
  • Newsletter
  • Contact
Follow US

Home » SCCM » SCCM 1606 Upgrade SQL Server 2014 to SQL Server 2016

SCCMSQL Server

SCCM 1606 Upgrade SQL Server 2014 to SQL Server 2016

By Prajwal Desai 1 View 7 comments September 20, 2017 4 Min Read

SCCM 1606 Upgrade SQL Server 2014 SQL Server 2016 – In this post we will see the steps to upgrade SQL server 2014 to SQL Server 2016. This post is related to SCCM as we will be performing an inplace upgrade of SQL Server 2014 to 2016 installed for SCCM. Before upgrading the SQL server in production environment, it is advised that you test the upgrade on a test environment. You can download SQL Server 2016 from the Evaluation Center.

SCCM 1606 Upgrade SQL Server 2014 SQL Server 2016

With the release of SQL server 2016, the upgrade paths from previous versions are available here. You can upgrade from SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, and SQL Server 2014 to SQL server 2016. Before you upgrade take a look at those upgrade paths. Check if your SQL server version can be upgraded to SQL server 2016.

My Test Setup – In my test setup, I am running Configuration Manager version 1606. I have upgraded Configuration Manager 1511 to 1606. The site database is hosted on SQL server 2014 enterprise edition. So in my case the supported upgrade path is upgrade to SQL server 2016 enterprise edition.

Just remember that I have performed the upgrade in my test environment. Therefore I advise you to do the same first. If you find SCCM 2016 and SQL 2016 stable then upgrade it in production environment.

- Advertisement -
Ad image

Before you upgrade :

  1. Ensure your SQL server version is eligible for upgrade to SQL server 2016.
  2. The operating system should be compatible on which you are performing an SQL upgrade. So to verify you can check hardware and software requirements for Installing SQL Server 2016.
  3. Note that SQL Server 2016 is only available for 64-bit platforms. Hence cross-version instances of SQL Server 2016 are not supported.
  4. Before you upgrade enable Windows Authentication for SQL Server Agent. In addition the SQL Server Agent service account should be a member of the SQL Server sysadmin group.
  5. If you are running evaluation edition of SQL server then upgrade to SQL 2016 is not possible.

Begin SQL server 2016 Installation

Mount the SQL server 2016 iso file and run the setup as administrator. On the SQL server installation center, click on Installation. Next click on Upgrade from a previous version of SQL server. SCCM 1606 Upgrade SQL Server 2014 to SQL Server 2016 Snap1Click I accept the license terms and click Next.

SCCM 1606 Upgrade SQL Server 2014 to SQL Server 2016Click on Next. On the upgrade rules dialog you should see all the rules as passed. Click Next.

SCCM 1606 Upgrade SQL Server 2014 to SQL Server 2016Select the instance of SQL server. Click Next.

SCCM 1606 Upgrade SQL Server 2014 to SQL Server 2016Click Next.

SCCM 1606 Upgrade SQL Server 2014 to SQL Server 2016On the instance configuration dialog, click Next.

SCCM 1606 Upgrade SQL Server 2014 to SQL Server 2016Finally click on Upgrade.

SCCM 1606 Upgrade SQL Server 2014 to SQL Server 2016If the upgrade is successful you see a dialog box which shows computer restart required. The summary log file location is shown at the bottom of dialog. Click OK. Close the installation wizard and reboot the server.

SCCM 1606 Upgrade SQL Server 2014 to SQL Server 2016My Observations – After upgrading to SQL server 2016, I have not observed any issues. In conclusion the SCCM 2016 is working fine. The performance of SQL server 2016 is really good. I will update this post in case i find any issues.

Sign Up For Weekly Newsletter

Get the most recent information on Configuration Manager, Intune, Windows 11, Windows 365, Autopilot, Azure, Software Reviews, and much more by subscribing to the newsletter.
By signing up, you agree and acknowledge the data practices in our Privacy Policy. You may unsubscribe at any time.
Share this Article
Facebook Twitter Copy Link Print
Avatar photo
By Prajwal Desai
Follow:
Prajwal Desai is a Microsoft MVP in Enterprise Mobility. He writes articles on SCCM, Intune, Configuration Manager, Microsoft Intune, Azure, Windows Server, Windows 11, WordPress and other topics, with the goal of providing people with useful information.
Previous Article PS bann Get Configuration Manager Client Cache Size using PowerShell
Next Article ice Mountain How to Update Configuration Manager Cmdlet Library
7 Comments 7 Comments
  • Avatar photo Fazza says:
    June 12, 2019 at 5:19 pm

    I get an extra option asking if I want to rebuild the database or not but not sure if I do or not?

    Reply
  • Avatar photo Nick says:
    February 8, 2019 at 5:13 pm

    Hi,
    I have SCCM 1806 and SQL 2014 and WS 2012 R2 server. Could I upgrade to SQL 2017 directly? And after upgrade the SQL 2014 to SQL 2017, I can upgrade WS 2012 R2 to WS 2019. Is that possible? Do you have any guides?

    Reply
    • Avatar photo Prajwal Desai says:
      February 11, 2019 at 11:27 am

      I guess yes. I don’t have the guides with me at the moment.

      Reply
  • Avatar photo saffi says:
    January 9, 2019 at 12:21 pm

    Hi Prajwal,
    what will do with SQL express edition i have CM 2012 Sp1 console and site version 5.00.8239.1000 with signle site running in Production Environment almost 1100 workstation please guide thanks very much in advance!

    Reply
  • Avatar photo SCCM_buff says:
    April 6, 2017 at 6:47 pm

    what will be steps in if you have more than one Site server, I.e first cas then Primary and then secondary ?

    Reply
  • Avatar photo Prajwal Desai says:
    February 6, 2017 at 2:32 pm

    Yes it does support. https://technet.microsoft.com/en-us/library/gg682077.aspx#BKMK_SupConfigSQLDBconfig

    Reply
  • Avatar photo yuvaraj says:
    February 3, 2017 at 10:54 pm

    Hi PrajwalDesai, I have SCCM 2012 r2 SP1 infrastructure with SQL server 2008 r2 sp1. I am planning to process a SQL server upgrade in the first week followed by SCCM server upgrade in the next week. Please let me know does sccm 2012 r2 supports SQL server 2016.

    Thanks for your help!

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recast Sponsored AD
Ad image
Patch My PC Sponsored AD
Ad image

Latest Articles

Fix Windows Autopilot Reset Error 0x80070032
Fix Windows Autopilot Reset Error 0x80070032
Autopilot Intune
Windows activation error 0xc004c020
Fix: Windows Activation Error 0xC004C020 with 2 Easy Methods
Windows 11 Windows 10
Find the Package ID of SCCM Application
3 Best Ways to Find the Package ID of SCCM Application
SCCM
SCCM Updates Install Error 0x800b0109 0x8024b303
Fix: SCCM Updates Install Error 0x800b0109 | 0x8024b303
SCCM
Subscribe to Our Newsletter

Subscribe to our newsletter to get our newest articles instantly!

You Might Also Like

Find the Package ID of SCCM Application
SCCM

3 Best Ways to Find the Package ID of SCCM Application

By Prajwal Desai
SCCM Updates Install Error 0x800b0109 0x8024b303
SCCM

Fix: SCCM Updates Install Error 0x800b0109 | 0x8024b303

By Prajwal Desai
ConfigMgr Technical Preview 2302 New Features
SCCM

ConfigMgr Technical Preview 2302 New Features | Baseline Version

By Prajwal Desai

Removed from reading list

Undo
Welcome Back!

Sign in to your account

Lost your password?