How to upgrade SQL Server 2012 Evaluation Edition to Standard or Enterprise

20170522112224SQL Server 2012 Evaluation Edition was installed on a server as a temporary measure with a view of upgrading it to Enterprise Edition at some stage in the future. Thankfully the steps were quite straight-forward and did not require building a new server and migrating data etc. I had no idea that SQL Server 2012 was still on the Evaluation Edition until one day the backups started failing, no doubt after the 180 evaluation period had expired. When opening SQL Server Management Studio I saw the following warning:

20170425204909

The steps below will show you how to upgrade SQL Server 2012 Evaluation Edition to Enterprise Edition (same steps apply for Standard Edition).

The Upgrade Process

1. Locate the SQL Server 2012 install media and mount it to the desired server.

2. Run the media, select Maintenance and click on Edition Upgrade:

20170425205141

3. On the Setup Support Rules section, click OK:

20170425205245

4. Then click Next:

20170425205448

5. Enter your product key then click Next :

20170425205604

6. Check I accept the license terms and click Next:

20170425205857

7. Select the instance that needs to be upgraded, in my case it was SANDBOX, then click Next:

20170425210108

8. Assuming no failures are detected during the compatibility check, click Next to proceed:

20170425210302

9. Click Upgrade for the upgrade process to begin:

20170425210434

10. Once the upgrade process has completed click on Close:

20170425212020

11. To verify SQL Server 2012 has been upgraded successfully, login to the instance via SQL Server Management Studio:

20170425212144

12. Within Server Properties you will observe the Product is now listed as Microsoft SQL Server Enterprise (64-bit):

20170425212837

That’s it! :)

References:
Upgrade to a Different Edition of SQL Server (Setup)

Remote Desktop section missing from Remote Tab in Windows Server 2008 R2 Enterprise

In a previous post I demonstrated how to perform an in-place upgrade from Windows Server 2008 R2 Standard to Enterprise using the DISM tool. The actual upgrade process went as planned, however, I noticed that I couldn’t connect to the server via RDP. When connecting via the console in the vSphere Client I noticed that the Remote Desktop section was missing from Remote Tab:

20150620004030

The Fix

To resolve this issue perform the following steps:

1. Run this command:

slmgr.vbs /ipk XXXXX-XXXXX-XXXXX-XXXXX-XXXXX

You should then receive the pop-up box confirming the successful product key install:

20150620005645

2. Then run the command below to activate the product key:

slmgr.vbs /ato

You should then see another pop-up box confirming the successful activation:

20150519151724

3. You will then receive a warning asking you to reboot the server:

20150620010007

Follow the instruction and reboot the server.

4. Once it comes back up the Remote Desktop section of the Remote tab will now be visible:

20150620010441

The Happy Ending

You should then be able to connect to the server via RDP and carry on with your admin duties.

Reference(s):
Remote Desktop missing from Remote Tab – Server 2008 R2 Enterprise