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 a lot of companies are planning to upgrade their configuration manager environment. One important aspect during upgrade is the supported SQL server version. In this post I will try my best to list the SQL versions supported for SCCM current branch. This will help you out in choosing the SQL server during configuration manager install or upgrade. If you are looking at size and scale numbers for System Center Configuration Manager click this link.
Supported SQL Server versions for SCCM Current Branch
When you install SQL Server to host your site database you need to remember few things. To host your site DB the configuration manager supports 64 bit version of SQL server. 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 secondary sites, the site DB can use 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 comptuer.
The SQL collation must be set to SQL_Latin1_General_CP1_CI_AS. You must also limit the SQL server memory. However if you don’t change the SQL memory limit options, SQL Server can change its memory requirements dynamically based on available system resources. You can take a look at this post where I have shown how to install SQL for SCCM.
The below table lists the SQL Server version supported by System Center Configuration Manager version 1511 and later. You can use the below versions of SQL Server with no minimum cumulative update version.
|SQL Server 2016 Express||NO||NO||YES|
|SQL Server 2016 (Standard, Enterprise)||YES||YES||YES|
|SQL Server 2014 SP2 (Standard, Enterprise)||YES||YES||YES|
|SQL Server 2014 SP1 (Standard, Enterprise)||YES||YES||YES|
|SQL Server 2014 Express SP2||NO||NO||YES|
|SQL Server 2014 Express SP1||NO||NO||YES|
|SQL Server 2012 SP3 (Standard, Enterprise)||YES||YES||YES|
|SQL Server 2012 SP2 (Standard, Enterprise)||YES||YES||YES|
|SQL Server 2012 Express SP3||NO||NO||YES|
|SQL Server 2012 Express SP2||NO||NO||YES|
|SQL Server 2008 R2 SP3 (Standard, Enterprise)||YES||YES||YES|