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 http://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