SQL SERVER – Product Key for Developer Edition, Enterprise Evaluation Edition and Express Edition

During the recent consulting engagement Comprehensive Database Performance Health Check with SQL Server 2017/2019, my client’s DBA asked me that they want PID for free editions of SQL Server. In this blog, I would share my findings and Product Key for Developer Edition, Enterprise Evaluation Edition, and Express Edition.

SQL SERVER - Product Key for Developer Edition, Enterprise Evaluation Edition and Express Edition productkey-800x294

As you might already know these facts but those who don’t know, let me reiterate in simple terms.

  1. Enterprise Evaluation Edition is a free (for 180 days) edition. All features are the samPorducte as Enterprise Edition.
  2. Express Edition is a scaled-down edition of SQL with some limitations but allowed for production use.
  3. Developer Edition is a free edition (starting SQL 2016 onwards) which is allowed only for development but not for production purposes. All features are the same as Enterprise Edition.

If we install these editions using setup wizards, then we can choose them in the below screen.

SQL SERVER - Product Key for Developer Edition, Enterprise Evaluation Edition and Express Edition PID-dev-eval-exp

How would you specify them in the command line? Based on my trial and error, I found that if we want PID for these free editions then here are the keys that can be used.

Product Key

  1. Evaluation: 00000-00000-00000-00000-00000
  2. Express: 11111-00000-00000-00000-00000
  3. Developer: 22222-00000-00000-00000-00000

Once you enter these values and press “Next” then you can verify and see the edition in the next screen which shows License Terms. This would be useful when you want to deploy using a script or command line.

Here are a few additional blog posts on a similar topic which you may find it helpful:

SQL SERVER – Evaluation Period Has Expired – How to Activate SQL Server?
If the SQL Server engine is expired, the SQL services would not start and you will find below error in SQL Server error log and event viewer. Here is the blog to find a SQL ERRORLOG file location.

SQL SERVER – Understanding Licensing Models
SQL Server is available under three different licensing models.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

, ,
Previous Post
SQL SERVER – Removing Additional Transactional Log Files
Next Post
SQL SERVER – Scrollbar in the Middle – Bugs Fixed by SSMS Team

Related Posts

3 Comments. Leave new

  • I currently have SQL 2014 SP2 Developer Edition installed on a 2 node SQL cluster. The server needed to have Enterprise Core-based Licensing installed. Any chance this is supported by MS? Are there any good options to upgrade this?

    Reply
  • Thank you, this information helped me prove a script with dbatools.io to install a database instance using the 2019 Developer edition

    Reply
  • Irfaan Sulaiman
    May 15, 2020 6:19 pm

    Thank You so much! You are a STAR!!!

    Reply

Leave a Reply

Menu