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.
Note
The information presented here does not apply to System Center 2012 Configuration Manager. For those system requirements, see https://go.microsoft.com/fwlink/p/?LinkId=248315
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 component | SQL Server 2008 R2 SP1 Standard, Datacenter | SQL Server 2008 R2 SP2 Standard, Datacenter | SQL Server 2008 R2 SP3 Standard, Datacenter | SQL 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 | ● | ● | ● | ● |
SQL Server 2012 AlwaysOn Support
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.
See Also
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