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
Thank you Alexandre, it was very helpful. I am preparing my sccm 2k12r2 lab for some testing and I had exact the issue with it 🙂 Your blog entry helped me very much. Havea a good day. Merry Christmas ! 🙂
Your blog also helped me very much 🙂
I used 480671_ENU_x64_zip fix so my SCCM 2012 would install on a SQL 2014 server.
Thanks so much. I was running SQL 2014 and getting this error during my SCCM 2012 install. The link your provided had two hotfixes available but following your directions to use ConfigMgr12_R2_QFE_KB3020755_X64_ENU_OOB worked perfectly. Thanks for spending some time sharing this fix!