SQL Server in System Center 2012 SP1


Published: February 8, 2016

Updated: August 4, 2017

Applies To: System Center 2012 SP1

This topic lists the versions of Microsoft SQL Server that are supported for each System Center 2012 SP1 component.

System_CAPS_ICON_note.jpg Note

The information presented here does not apply to System Center 2012 Configuration Manager. For those system requirements, see http://go.microsoft.com/fwlink/p/?LinkId=248315

System_CAPS_ICON_note.jpg Note

SQL Server 2008 R2 SP3 is only supported if you have installed Update Rollup 9 for Operations Manager 2012 SP1.

System Center 2012 SP1 componentSQL Server 2008 R2 SP1 Standard, DatacenterSQL Server 2008 R2 SP2 Standard, DatacenterSQL Server 2008 R2 SP3 Standard, DatacenterSQL Server 2012 Enterprise, Standard (64-bit)SQL Server 2012 SP1 Enterprise, Standard (64-bit)SQL Server 2012 SP2 Enterprise, Standard (64-bit)SQL Server 2012 SP3 Enterprise, Standard (64-bit)SQL Server 2014 Enterprise, Standard (64-bit)SQL Server 2014 with SP1 Enterprise, Standard (64-bit)
App Controller Server
Data Protection Manager (DPM) Database

(from DPM 2012 SP1 with Update Rollup 6 onwards)
Operations Manager Data Warehouse
Operations Manager Operational Database
Operations Manager Reporting Server
Orchestrator Management Server
Service Manager Database or Data Warehouse Database
Virtual Machine Manager (VMM) Database Server

In System Center 2012 SP1, SQL Server 2012 AlwaysOn is supported in the following components:

  • App Controller

  • Operations Manager

  • Orchestrator

  • Service Manager

For VMM, SQL Server AlwaysOn is supported. However, if you want to use AlwaysOn Availability Groups then only synchronous-commit availability mode is recommended. For more information, see System Requirements: VMM Database in System Center 2012 and in System Center 2012 SP1.

SQL Server AlwaysOn isn't supported with Data Protection Manager (DPM) and Configuration Manager.

A Word document describing SQL Server 2012 AlwaysOn is available at SQL Server 2012 AlwaysOn: Multisite Failover Cluster Instance.

Getting Started with System Center 2012 - App Controller
System requirements for DPM
System Requirements for System Center 2012 - Operations Manager
System Requirements for Orchestrator
Planning for System Center 2012 - Service Manager Deployment
System Requirements: VMM 2012 and VMM 2012 SP1