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 http://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 http://support.microsoft.com/kb/2673382/. If you are running SQL 2008 SP3, install CU4 from http://support.microsoft.com/kb/2673383/. If you are running SQL Server 2008 R2 SP1, use CU6 from http://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 http://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, http://support.microsoft.com/kb/2679368/.