You Need To Know : Configuration Manager 2007 and System Center 2012 Configuration Manager Service Pack 1 now support Microsoft SQL Server 2012 SP1

  • Article

   Hi All :

   We are announcing support changes for the following releases. These changes will be reflected in the Configuration Manager 2007 Supported Configurations and System Center 2012 Configuration Manager Supported Configurations within the next month.

Configuration Manager 2007 and System Center 2012 Configuration Manager Service Pack 1 now support Microsoft SQL Server 2012 SP1.

The following table lists the roles/features that are supported for each product with Microsoft SQL Server 2012 SP1.

Product

Roles / Features Supported

Configuration Manager 2007 SP2*

Site Database

Configuration Manager 2007 R3*

Reporting services point

Client status reporting

System Center 2012 Configuration Manager SP1

Site database

Secondary site database**

*  For Configuration Manager 2007 SP2 and R3, hotfix KB2676776 https://support.microsoft.com/kb/2676776 is required.

** For a System Center 2012 Configuration Manager SP1 secondary site, you can use SQL Server 2012 SP1 or SQL Server Express 2012 SP1.

No software updates are required for System Center 2012 Configuration Manager SP1.

Note:  System Center 2012 Configuration Manager RTM (no service pack) does not support SQL Server 2012 or SQL Server 2012 SP1.


Forefront Endpoint Protection 2010 (FEP 2010) now supports SQL Server 2012 SP1.

Forefront Endpoint Protection 2010 now supports upgrading an existing Forefront Endpoint Protection database and reporting database to Microsoft SQL Server 2012 SP1.

To use SQL Server 2012 SP1 with Forefront Endpoint Protection 2010, you must upgrade the existing instance of SQL Server from SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012. It is not supported to install new Forefront Endpoint Protection components on an existing or new instance of SQL Server 2012 or SQL Server 2012 SP1.

The following update is required to use Forefront Endpoint Protection with Microsoft SQL Server 2012 and 2012 SP1.

Forefront Endpoint Protection data warehouse and reports fail to get new data on SQL Server 2012 - https://support.microsoft.com/kb/2683558


System Center Security Monitoring Pack for Endpoint Protection now supports System Center 2012 Operations Manager SP1.

No software updates are required.

 

 

 Enjoy!

 Justin Gao

 Microsoft (China)