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.
Issue
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.
Fix
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.
More
SCCM Team wrote a post on this topic here