Supported SQL Server versions for SCCM Current Branch

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 ServerCASPRIMARYSECONDARY
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

 

You might also like

15
Leave a Reply

avatar
12 Comment threads
3 Thread replies
0 Followers
 
Most reacted comment
Hottest comment thread
newest oldest most voted
Sajeesh
Guest
Sajeesh

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

Minzy
Guest
Minzy

Good day Prajwal ,

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

ranjith
Guest
ranjith

which sql reporting service suported to sccm 1702..

ivTor
Guest
ivTor

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

ivTor
Guest
ivTor

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

rajeevGautam
Guest
rajeevGautam

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

Vinod
Guest
Vinod

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,

Duraimurugan Angamuthu
Guest
Duraimurugan Angamuthu

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

Oscar
Guest
Oscar

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

Craig
Guest
Craig

Will 1706 work with SQL 2012?

Fred Rouse
Guest
Fred Rouse

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.

SCCM_buff
Guest
SCCM_buff

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

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. AcceptRead More