Trying to install ConfigMgr 2012 RTM? Make sure you have the right SQL…
Now that Configuration Manager 2012 RTM is available, people will certainly start installing it, both in their labs and in production – and will start finding out that the SQL version check in the ConfigMgr installer is looking for some very specific SQL maintenance levels. (I’ve pulled out plenty of my own hair doing this recently, just like I did with the prerelease versions.) The supported versions can be found at https://technet.microsoft.com/library/gg682077.aspx#BKMK_SupConfigSQLDBconfig. The summary (always subject to change):
- SQL Server 2008 SP2 Standard and Enterprise CU9
- SQL Server 2008 SP3 Standard and Enterprise CU4
- SQL Server 2008 R2 SP1 and CU6
- SQL Server Express 2008 R2 and CU4 (secondary sites only)
If you are running SQL 2008 SP2, install CU9 from https://support.microsoft.com/kb/2673382/. If you are running SQL 2008 SP3, install CU4 from https://support.microsoft.com/kb/2673383/. If you are running SQL Server 2008 R2 SP1, use CU6 from https://support.microsoft.com/kb/2679367/. If you aren’t yet on the needed service pack levels, upgrade now, then install the cumulative updates :-)
I’m still looking for a statement on ConfigMgr 2012 RTM and SQL Server 2012. (ConfigMgr 2007 now supports it, see https://blogs.technet.com/b/configmgrteam/archive/2012/04/17/configuration-manager-support-announcements-for-april-2012.aspx.) There’s already a CU1 for SQL Server 2012, https://support.microsoft.com/kb/2679368/.
Comments
Anonymous
January 01, 2003
No, the MDT database isn't nearly as picky - it will use any currently-supported version of SQL Server (and probably ones that aren't supported too, but we don't test those).Anonymous
April 27, 2012
Are these SQL requirements the same for installing the database in newest MDT2012?Anonymous
May 29, 2012
I have SQL 2008 SP3 but I can't get the CU4 or any CU to installed, what gives...Anonymous
December 23, 2012
Hi Michael, Is Cumulative update package 14 for SQL Server 2008 R2 compatible with SCCM 2012? Thanks :)