SQL Server

SQL Server 2014 – How to change the Product Key

Sometimes, you may need to change the product key, the license, of an existing SQL Server installation.  This can happen if you installed the product in Evaluation mode or if you want to upgrade to Enterprise from Standard edition. Fortunately, this modification does not require to uninstall and reinstall SQL Server. It can be done using Setup Wizard.

SQL Server Product Key

SQL Server Product Key

But, you may not have the Product Key displayed in your msdn subscription portal.  It can be find in the .iso file that you downloaded from the website.

Let’s see how to do that:

Continue reading

SCCM

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.

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