Extract SQL Server 2012 Product Key from MSDN or SPLA media

20170522112224When you install SQL Server 2012 using MSDN or SPLA media you never see the actual license. In my case, my company uses the Microsoft Services Provider License Agreement  (SPLA) which is for service providers and independent software vendors (ISVs) who want to license Microsoft software products to provide software services and hosted applications to end customers. SPLA Licensing for SQL Server is pre-pidded, where product key is actually built into the installer.  So if you need to apply that SPLA product key to another SQL Server instance, it needs to be extracted from the SQL Server 2012 ISO. The steps below will show how this can be done.

Finding the Product Key

1. Locate the SQL Server 2012 media and mount it:

20170526003234

2. Once mounted open the relevant drive in Windows Explorer and open the x64 folder:

20170526002844

3. Locate the DefaultSetup.ini file:

20170526002944

4. Open it in Notepad and make a note of the the Product Key:

20170526002647

That’s it! Now that you have obtained the Product Key you can apply it to another SQL Server Instance. If you want instructions on how to do this, following the instructions in this post.

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)