System Center 2012 Configuration Manager SP1 and System Center 2012 R2 Configuration Manager now support the following versions of Microsoft SQL Server 2014.
SQL Server 2014 Standard (CAS, Primary site, Secondary site)
SQL Server 2014 Enterprise (CAS, Primary site, Secondary site)
SQL Server 2014 Express (Secondary site)
New site database installations and upgrading an existing site database from one of the following SQL Server versions are now both supported.
SQL Server 2012
SQL Server 2008
SQL Server 2008 R2
The reporting services point site system and client status reporting feature are also supported with SQL Server 2014.
The following software updates are required in order to use SQL Server 2014 to host the site database:
For System Center 2012 R2 Configuration Manager and System Center 2012 Configuration Manager Sp1:
Restore fails when the site database uses SQL Server 2014 on a server that is running System Center 2012 R2 Configuration Manager
. This hotfix is independent of the cumulative update level of the Configuration Manager site.
Windows Server Update Services (WSUS) 3.0 SP2 Server cannot be installed on Windows Server 2008 R2 SP1 or Windows Server 2008 SP2 with SQL Server 2014 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.