TechNet
Export (0) Print
Expand All

SQL Server in System Center 2012 SP1

 

Published: February 8, 2016

Updated: July 21, 2016

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_noteNote

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_noteNote

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

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.

Show:
© 2016 Microsoft