Supported SQL Server versions for SCCM | ConfigMgr

In this post, we will look at the supported SQL server versions for SCCM current branch. When you install SCCM, you require SQL server to host the site database. This SQL server version should be supported by Configuration Manager.

With the release of SCCM 1606 many organizations are planning to upgrade their configuration manager environment. One important aspect during the ConfigMgr upgrade is to determine whether the installed SQL server version is compatible or not.

This article lists all the SQL server supported versions for SCCM current branch. This will help you out in choosing the SQL server version during configuration manager install or upgrade. If you are looking for size and scale numbers for Configuration Manager refer to this link.

When you install SQL for CAS and Primary sites, site database always uses full install of SQL. The SQL server can be on site server computer, or it could be on a remote computer.

For SCCM Secondary sites, the site DB can use a default instance of a full install of SQL Server, or SQL Server Express. However, the SQL Server cannot be remote in this case. It should be on the site server computer.

Read: How to install SQL Server 2019 for SCCM

SCCM Configurations for SQL Server

Listing some of the important configurations required for all SQL server installs.

  • Configuration Manager requires a 64-bit version of SQL Server to host the site database.
  • While installing SQL server for SCCM, the site database must use the following Database collation: SQL_Latin1_General_CP1_CI_AS.
  • Only the Database Engine Services feature is required for each site server.
  • SCCM requires Windows authentication to validate connections to the database.
  • Take a look at SQL Server Memory Configurations.
  • SQL Server ports: The Intersite communications use the SQL Server Service Broker, which uses port TCP 4022 by default. And the Intrasite communications between the database engine and various ConfigMgr site system roles use port TCP 1433 by default.

Supported SQL Server versions for SCCM Current Branch

The below table lists all the supported SQL server versions for SCCM current branch. You can use the below versions of SQL Server with no minimum cumulative update version.

Supported SQL Server Versions for SCCMSCCM CAS SiteSCCM Primary SiteSCCM Secondary Site
SQL Server 2019 (Standard, Enterprise) with cumulative update 5 YES YES YES
SQL Server 2017 Express with minimum CU2 or higherNONOYES
SQL Server 2017 (Standard, Enterprise)YESYESYES
SQL Server 2016 ExpressNONOYES
SQL Server 2016 (Standard, Enterprise)YESYESYES
SQL Server 2014 SP2 (Standard, Enterprise)YESYESYES
SQL Server 2014 SP1 (Standard, Enterprise)YESYESYES
SQL Server 2014 Express SP2NONOYES
SQL Server 2014 Express SP1NONOYES
SQL Server 2012 SP3 (Standard, Enterprise)YESYESYES
SQL Server 2012 SP2 (Standard, Enterprise)YESYESYES
SQL Server 2012 Express SP3NONOYES
SQL Server 2012 Express SP2NONOYES
SQL Server 2008 R2 SP3 (Standard, Enterprise)YESYESYES
Supported SQL Server versions for SCCM Current Branch

Leave a Reply

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

18 Comments

  1. Can we use SQL 2019 Developer edition for Pre-prod SCCM environment instead of SQL 2019 enterprise/Standard editions.

  2. hi,
    What about SQL 2019?

  3. Avatar photo Joe Popich says:

    Was really hoping to see Azure SQL Managed instance support 🙁

  4. Hi Prajwal,

    I am currently using Configuration manager version 2012 SP2 and the database sql 2008 R2 (10.50.4042.0)
    Now we are planning to migrate SQL server to a new server with a later version of SQL ( SQL 2017 server). Is this possible?
    If not, which version of SQL DB i can install in new server.

    Thank you,
    SK

  5. Good day Prajwal ,

    May I know SCCM version 1802 can work with SQL 2014 ?
    Thank you

    1. Yes, but use SQL Server 2014 SP3 or latest service pack available for SQL 2014.

  6. which sql reporting service suported to sccm 1702..

  7. Hi prajwal

    it is supported to have the database in version 2016 and the report instance in sql 2012

    i dont find anything about that

    thx

  8. Hi Prajwal

    it is supported to have the database in version 2016 and the report instance in sql 2012?

    i dont find anything about that

    thx

  9. Avatar photo rajeevGautam says:

    What about the developer version of SQL server 2017 will it work with SCCM

  10. Hi Prajwal,
    Since sccm 2016 comes with bundled licensing, it has sql2016 ent. license within it, can we deploy sql2016 on a different server instead of parent primary site server and still use that bundled license feature of sql on it.
    Second, how do we achieve the sql High availability for sccm with bundled licensing.

    Thanks,

  11. Avatar photo Duraimurugan Angamuthu says:

    HI, Will SQL 2012 Express SP2 CU5 work for CB 1706

  12. Hi I currently have SCCM 2012 R2 SP1 Site Version 5.00.8239.1000 and a SQL Server 2008 R2 SP2. I would like to upgrade to CB 1606 but I’ve noticed that you need at least SQL Server 2008 R2 SP3. My question is, can I upgrade my sql box to SP3 and then upgrade to CB 1606? Or will this not work?
    Thanks
    Oscar

  13. Will 1706 work with SQL 2012?

  14. Avatar photo Fred Rouse says:

    Hi Prajwal,
    I have installed SCCM and the problem I’m having is the client install. I can not get it to install on a client workstation. I have tried to install it manually and from the SCCM server. I can see the ccmsetup.exe *32 in task manager on the Windows 7 64 bit workstation, but it doesn’t install the config manager client. Please Help. I don’t know if my distribution point is the issue or if it’s something else.

    1. Did you examine the client installation log files ?. Log files should reveal the reason of failure.

  15. Avatar photo SCCM_buff says:

    HI, Will SQL 2012 Express CU2 Applied will work for CB 1606 ?