Which one to download?


I just logged into MS licensing page. We purchase sql 2014. But it has sp1, sp2..
1. which one should we download?
2. Also, when I click on the key, they all say the key is not needed. How should I get key?

Who is Participating?
Pawan KumarConnect With a Mentor Database ExpertCommented:
Hi Mcrmg,

The URL you gave is incorrect. The correct one is - https://www.microsoft.com/en-us/download/details.aspx?id=53164

Also download the latest version. The URL I mentioned is the latest version of 2014, SP2.

Also, when I click on the key, they all say the key is not needed.

This is normal.

From SQL 2008 onwards (2008 R2, 2012, 2014), the SQL Server setup media comes with pre-pidded (except Evaluation and Express editions) Whenever you invoke setup.exe from that location, the Product key would be picked automatically and filled in the screen.

Here Microsoft says the product key is included with this product. The product key will be hard coded in the area where you are supposed to enter the product key. Because of this it is possible to install the product multiple times without activation issues.

How should I get key?


EXEC xp_regread 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL12.MSSQLSERVER2014\Setup','ProductCode'


Open in new window

Value      Data
ProductCode      {C8500A82-P9FD-4B6D-B1B2-111111D2B48A}

For understanding the licensing you need to follow the URL -


Hope it helps.
Éric MoreauSenior .Net ConsultantCommented:
you should always install the latest (sp2 in this case).

your image is not from MSDN. Where are you downloading your software from?
mcrmgAuthor Commented:
This is the website I go to


But it says key is not required. and they are two sp2.
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Éric MoreauConnect With a Mentor Senior .Net ConsultantCommented:
volume licensing is a special licensing mode for large organisation. I don't use it so I will let other answer that question.

about the 2 SP2:
-the first one is only the service pack (to download if you already have SQL Server installed)
-the second (with SP2) is the full installation package including SP2 (if you have nothing already installed)
mcrmgAuthor Commented:
thanks for the clarification.
mcrmgAuthor Commented:
thank you. I will try that on Monday and post back.
mcrmgAuthor Commented:
I still have idea how the key was populated by itslef, lol, but it works...thanks
mcrmgAuthor Commented:
thank you very much
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.