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
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 →
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
During the installation of Microsoft SQL Server, you have two choices regarding the account used to start the “SQL Server” service:
- Local System of the computer.
- Service account, user account, created in Active Directory.
Microsoft recommends to use the service account instead of local system. However, when using service account, you can have this error in SQL Logs:
The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Failure to register a SPN might cause integrated authentication to use NTLM instead of Kerberos
Continue reading →