SQL Server Version for ConfigMgr 2012


I’m always looking for the SQL Version and need a place to store this links for easy access, maybe you are on the same situation and need the find out about the support SQL Version.

The following table lists the SQL Server versions that are supported by System Center 2012 Configuration Manager and the links to download the CU’s or Service Packs.









SQL Server version

SQL Server service pack

Minimum required SQL Server cumulative update

Configuration Manager version

Configuration Manager site type

SQL Server 2008

  • StandardPointing up
  • Enterprise
  • Datacenter

SP2

10.00.4000

Minimum of cumulative update 9

 

  • System Center 2012 Configuration Manager with no service pack
  • System Center 2012 Configuration Manager with SP1
  • System Center 2012 R2 Configuration Manager

  • CAS
  • Primary site
  • Secondary site

SP3

10.00.5500

Minimum of cumulative update 4

  • System Center 2012 Configuration Manager with no service pack
  • System Center 2012 Configuration Manager with SP1
  • System Center 2012 R2 Configuration Manager

  • CAS
  • Primary site
  • Secondary site

SQL Server 2008 R2

  • StandardPointing up
  • Enterprise
  • Datacenter

SP1

10.50.2500

Minimum of cumulative update 6

  • System Center 2012 Configuration Manager with no service pack2
  • System Center 2012 Configuration Manager with SP1
  • System Center 2012 R2 Configuration Manager

  • CAS
  • Primary site
  • Secondary site

SP2

10.50.4000

No minimum cumulative update

  • System Center 2012 Configuration Manager with no service pack2
  • System Center 2012 Configuration Manager with SP1
  • System Center 2012 R2 Configuration Manager

  • CAS
  • Primary site
  • Secondary site

SQL Server 2012

  • StandardPointing up
  • Enterprise

No service pack

Minimum of cumulative update 2

  • System Center 2012 Configuration Manager with SP1
  • System Center 2012 R2 Configuration Manager

  • CAS
  • Primary site
  • Secondary site

SP1

11.00.3000

No minimum cumulative update

  • System Center 2012 Configuration Manager with SP1
  • System Center 2012 R2 Configuration Manager

  • CAS
  • Primary site
  • Secondary site

Pointing upWhen you use SQL Server Standard for the database at the central administration site, the hierarchy can only support up to 50,000 clients. For more information, see Site and Site System Role Scalability.

Fingers crossed System Center 2012 Configuration Manager with no service pack does not support the site database on any version of a SQL Server 2008 R2 cluster. This includes any service pack version or cumulative update version of SQL Server 2008 R2. With Configuration Manager SP1, the site database is supported on a SQL Server 2008 R2 cluster.

 

Santos Martinez – Premier Field Engineer – ConfigMgr and Databases

Disclaimer: The information on this site is provided "AS IS" with no warranties, confers no rights, and is not supported by the authors or Microsoft Corporation. Use of any included script samples are subject to the terms specified in the Terms of Use

Comments (0)

Skip to main content