ConfigMgr 2012 Supported on SQL Server 2014, But Only If You Upgrade

If you're looking to use SQL Server 2014 as the basis for your ConfigMgr 2012 installation, there's a few caveats you should be aware of.

Rod Trent

April 30, 2014

1 Min Read
ConfigMgr 2012 Supported on SQL Server 2014, But Only If You Upgrade

Microsoft has released a support statement about running a System Center Configuration Manager 2012 SP1 and System Center Configuration Manager 2012 R2 on a SQL Server 2014 database – but there's a few caveats. Usually, when a support statement like this is released, Microsoft grants blanket supportability. But that's not the case here.

The first, most important caveat is that while SQL Server 2014 is supported as a site database, it must be an upgrade, not a new install. To use SQL Server 2014 as a site database provider, the site had to have been already running, and upgraded from SQL Server 2012, SQL Server 2008, or SQL Server 2008 R2. New ConfigMgr 2012 installations using SQL Server 2014 as the base is not supported.

One other caveat, important to a lot of people, is that WSUS will not work if installed on a Windows 2008 (R2 SP1 and SP2) server with SQL Server 2014 installed on it.

There are a couple other gotchas involved, too, including required updates and hotfixes required to run SQL Server 2014 with ConfigMgr 2012, so make sure you read through the official support announcement on Microsoft's System Center Configuration Manager Team Blog:

Support Announcements for April 2014

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like