SCCM 2012 – Installation with SQL Server 2014

System Center Configuration Manager 2012 R2 now supports SQL Server 2014. But you will have an error during the wizard if you try install SCCM 2012 SP1 /R2 on SQL Server 2014.


SCCM Installation Wizard checks the version of SQL Server. However, it treats SQL Server 2014 like a version not supported:

The SQL Server srvsql.lab.local is not accessible or its version not supported.


Microsoft released a patch to correct this problem. KB3020755
The description of the KB is “Restore fails when the site database” but we will copy dll into the Wizard folder.

We need to do 4 steps:

  • Download and extract the KB into a temporary folder.
  • Execute CM12-R2-QFE-KB3020755-X64-ENU-OOB.exe. It will extract 2 files : prereqcore.dll and setupcore.dll
  • Copy these files into the SMSSETUP\BIN\X64\ folder.
  • Exit and restart the installation Wizard.


SCCM Team wrote a post on this topic here


SCCM 2012 – How to deploy a KB using Application

Sometime, you need to deploy a KB using Application (.msu file) to your clients. Because it is not available in the Microsoft Update Catalog, you can not use Software Update to install it.

For example, to install App-V 5 on your clients, the Windows Management Framework 3.0 is a prerequisite for Windows 7. Windows 8 and 8.1 already include it.

This KB is not available in the catalog, we will use a Application to deploy it.

We will see how to deploy the Windows Management Framework 3.0 (KB2506143) using Application in System Center Configuration Manager 2012. With this method, you can link it as Dependency on another application and the installation can be automatically done. Continue reading