SQL Server Site Database Configuration

ConfigMgr, SCCM 2012 Leave a comment

Wondering what version of SQL Server you need to run with your version of SCCM 2012? Look no further than this support matrix from Microsoft.

The following table lists the SQL Server versions that are supported by System Center 2012 Configuration Manager.

SQL Server version SQL Server service pack Minimum required SQL Server cumulative update Configuration Manager version Configuration Manager site type
SQL Server 2008

  • Standard (see note 1)
  • Enterprise
  • Datacenter
 SP2 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
  • Central administration site
  • Primary site
  • Secondary site
SP3 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
  • Central administration site
  • Primary site
  • Secondary site
SP4 (see note 3) No minimum cumulative update
  • System Center 2012 Configuration Manager with SP1
  • System Center 2012 R2 Configuration Manager
  • Central administration site
  • Primary site
  • Secondary site
SQL Server 2008 R2

  • Standard (see note 1)
  • Enterprise
  • Datacenter
 SP1 Minimum of cumulative update 6
  • System Center 2012 Configuration Manager with no service pack
  • System Center 2012 Configuration Manager with SP1
  • System Center 2012 R2 Configuration Manager
  • Central administration site
  • Primary site
  • Secondary site
SP2 No minimum cumulative update
  • System Center 2012 Configuration Manager with no service pack
  • System Center 2012 Configuration Manager with SP1
  • System Center 2012 R2 Configuration Manager
  • Central administration site
  • Primary site
  • Secondary site
SP3 No minimum cumulative update
  • System Center 2012 Configuration Manager with SP1
  • System Center 2012 R2 Configuration Manager
  • Central administration site
  • Primary site
  • Secondary site
SQL Server 2012

  • Standard (see note 1)
  • Enterprise
 No service pack Minimum of cumulative update 2
  • System Center 2012 Configuration Manager with SP1
  • System Center 2012 R2 Configuration Manager
  • Central administration site
  • Primary site
  • Secondary site
SP1 No minimum cumulative update
  • System Center 2012 Configuration Manager with SP1
  • System Center 2012 R2 Configuration Manager
  • Central administration site
  • Primary site
  • Secondary site
SP2 No minimum cumulative update
  • System Center 2012 Configuration Manager with SP1
  • System Center 2012 R2 Configuration Manager
  • Central administration site
  • Primary site
  • Secondary site
SQL Server 2014

  • Standard (see note 1)
  • Enterprise
 No service pack No minimum cumulative update
  • System Center 2012 Configuration Manager with SP1 and a minimum of cumulative update 4 and the hotfix fromKB 2923078 (see note 2)
  • System Center 2012 R2 Configuration Manager with a minimum of cumulative update 1 (see note 2)
  • Central administration site
  • Primary site
  • Secondary site
SQL Server Express 2008 R2 SP1 Minimum of cumulative update 6
  • System Center 2012 Configuration Manager with no service pack
  • System Center 2012 Configuration Manager with SP1
  • System Center 2012 R2 Configuration Manager
  • Secondary site
SP2 No minimum cumulative update
  • System Center 2012 Configuration Manager with no service pack
  • System Center 2012 Configuration Manager with SP1
  • System Center 2012 R2 Configuration Manager
  • Secondary site
SP3 No minimum cumulative update
  • System Center 2012 Configuration Manager with SP1
  • System Center 2012 R2 Configuration Manager
 Secondary site
SQL Server 2012 Express No service pack Minimum of cumulative update 2
  • System Center 2012 Configuration Manager with SP1
  • System Center 2012 R2 Configuration Manager
  • Secondary site
SP1 No minimum cumulative update
  • System Center 2012 Configuration Manager with SP1
  • System Center 2012 R2 Configuration Manager
  • Secondary site
SP2 No minimum cumulative update
  • System Center 2012 Configuration Manager with SP1
  • System Center 2012 R2 Configuration Manager
  • Secondary site
SQL Server Express 2014 No service pack No minimum cumulative update
  • System Center 2012 Configuration Manager with SP1 and a minimum of cumulative update 4 and the hotfix fromKB 2923078 (see note 2)
  • System Center 2012 R2 Configuration Manager with a minimum of cumulative update 1 (see note 2)
  • Secondary site

Note – when you use SQL Server Standard for the database at the central administration site, the hierarchy can only support up to 50,000 clients.

Source

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s