How to update License Key or Product Key of SQL Server Instance

I was working in a project where I came to know client was using MSDN licenses on production environment. Though they have MS SQL Server license available but those SQL Server licenses were not applied on this production server. This can be major compliance issue if you are running your production system with MSDN license. I had suggested the same to client and convince them to apply available license key to the running SQL Server Instances in production.

Read attached article if you want to upgrade your SQL Server Evaluation Edition to Standard, Enterprise or Developer Edition. You can also activate your SQL Server Instance if its evaluation period has been expired using same article.

Note: – Take proper Full backup of your all databases before starting this activity. Make sure to create script of all Logins and SQL Server Agent Jobs etc. You can also Rename your Data folder where you have placed your database files to secure the databases during this process post stopping SQL Server services .

Read More:

Change SQL Server License key

Step 1- First step is to stop all SQL Server services. Launch SQL Server Configuration Manager and shutdown all services.

Step 2-  Copy SQL Server Enterprise/Standard edition setup to your server where you want to change the SQL Server product key. Run Setup.Exe with an Administrator account. SQL Server Installation Center will appear on your screen to proceed. Click on Maintenance tab from left side pane. You can see multiple options in right side pane. Select first option Edition Upgrade as shown in below image and click Next.

Step3- SQL Server will check all required rules, once all rules will be passed next button will enable to proceed. Click on Next button here.

sql server rules check

Step 4- Once you click on Next button of above screen, next window will come to enter the License Key or product Key of SQL Server Instance. Enter your Product Key or if EXE has a valid license key to cross verify then proceed for Next button with the same License key. Make sure that License key is not for MSDN or from any invalid source.

enter sql server product key

Step 5- Accept License Term and Condition and Click on Next button to proceed.

Step 6- Select MS SQL Server Instance for which you are going to change license key if you have multiple instances.

sql instance

Step 7- Click on Next button of above screen, it will check all rules for edition upgrade. If all rules shows as Passed you are good to go ahead. If your are getting any warning or error verify and try to fix it before going with the next step.

Step 8- Below will be the final window that prompt for Ready to upgrade the edition. Click on Upgrade button if all looks ok.

install sql server

Step 9- Once License will be updated below window will prompt with succeeded status.

Now you MSDN license has been changed to valid SQL Server Enterprise License. License will change based on the SQL Server setup you used for edition upgrade.

You might face Access Denied error during this edition upgrade, here is the solution to fix this error. You may get access denied error on SQL Server License.rtf file for that you need to uncheck read only attribute from file name.

license key file

 

If you have renamed your Data folder before starting this process as suggested in Note section, you can rename back it to Data folder again and then start the SQL Server services. Now, start MS SQL services which you have stopped initially before starting upgrade activity and check SQL Server Instance version and license type . You can see our output looks like below details.

Microsoft SQL Server 2012 (SP3) (KB#######) - 11.0.6020.0 (X64)
Date and time
Copyright (c) Microsoft Corporation
Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 <X64>
(Build 9600: ) (Hypervisor)

I hope you like this article. Please follow us on our facebook page and on Twitter handle to get latest updates.

Maruti Nandan

I am working at one of the top MNCs and have extensive experience on all versions of SQL Server since 2000,I have good hands on experience onfollowing database features: Database Mirroring, Always ON, Replication, Log Shipping, Geo-Clustering and Performance Tuning and delivered many SQL Server projects on consolidation, upgrades, heterogeneous replication, HA / DR solutions, automation and major performance tuning

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *