Skip to content

Enterprise Mobility + Security


System Center 2012 Configuration Manager SP1 and System Center 2012 R2 Configuration Manager support Microsoft SQL Server 2014 SP1

System Center 2012 Configuration Manager SP1 and System Center 2012 R2 Configuration Manager now support the following versions of Microsoft SQL Server 2014 SP1:

  • SQL Server 2014 SP1 Standard (CAS, Primary site, Secondary site)
  • SQL Server 2014 SP1 Enterprise (CAS, Primary site, Secondary site)
  • SQL Server 2014 SP1 Express (Secondary site)

The reporting services point site system and client status reporting feature are also supported with SQL Server 2014 SP1.

The following software updates are required to use SQL Server 2014 SP1 to host the site database:

Known limitations:

  • Windows Server Update Services (WSUS) 3.0 SP2 Server cannot be installed on Windows Server 2008 R2 SP1 and Windows Server 2008 SP2 with SQL Server 2014 SP1 installed. With this configuration, the Configuration Manager Software updates feature will not work correctly. WSUS 3.0 SP2 Server can be installed on Windows Server 2008 R2 SP1 and Windows Server 2008 SP2 with the Windows Internal Database (WID).  Please see the WSUS 3.0 SP2 System Requirements for additional information.

System Center 2012 Configuration Manager SP1 and System Center 2012 R2 Configuration Manager support Microsoft SQL Server 2008 SP4

System Center 2012 Configuration Manager SP1 and System Center 2012 R2 Configuration Manager now support Microsoft SQL Server 2008 SP4 for the Configuration Manager site database. 

The reporting services point site system and client status reporting feature are also supported with SQL Server 2008 SP4.

The following software updates are required to use SQL Server 2008 SP4 to host the site database:

  • For System Center 2012 R2 Configuration Manager and System Center 2012 Configuration Manager Sp1: https://support.microsoft.com/kb/3020755.  This hotfix is independent of the cumulative update level of the Configuration Manager site.

–Yvette O'Meally

 Configuration Manager Resources

Documentation Library for System Center 2012 Configuration Manager

System Center 2012 Configuration Manager Forums

System Center 2012 Configuration Manager Survival Guide

System Center Configuration Manager Support

This posting is provided "AS IS" with no warranties and confers no rights.