First published on CLOUDBLOGS on Apr 23, 2015
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.