Chris Nackers

ConfigMgr / SCCM

System Center 2012 Configuration Manager Database Requirements - 4/26/2012

2012-02-02

From the archive (2012). Written for the tools of the time, so some details may be out of date.

The below requirements are the listed requirements as of 4/26/2012 for ConfigMgr 2012.

Make sure to review the supported configurations on the TechNet site.

SQL Server Versions

  • SQL Server 2008 SP2 with CU9 (Standard or Enterprise)
  • SQL Server 2008 SP3 with CU4 (Standard or Enterprise)
  • SQL Server 2008 R2 with SP1 and CU6 (Standard or Enterprise)
  • SQL Server Express 2008 R2 with SP1 and CU4 (Secondary Sites)

NOTE: If you use SQL Server Standard, your CAS will only support 50k clients

Database Collation

ConfigMgr 2012 requires SQL_Latin1_General_CP1_CI_AS collation**.**

image

SQL Server Features

  • Only Database Engine Services is required. SQL Server replication is not needed.
  • Windows Authentication is required.
  • You must use a dedicated instance of SQL server.
  • It is HIGHLY recommended to limit the amount of memory assigned to SQL.