Solved

Which one to download?

Posted on 2016-10-15
8
64 Views
Last Modified: 2016-10-17
Hi,

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?


thanks
Capture.JPG
0
Comment
Question by:mcrmg
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
8 Comments
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 41845194
you should always install the latest (sp2 in this case).

your image is not from MSDN. Where are you downloading your software from?
0
 

Author Comment

by:mcrmg
ID: 41845233
This is the website I go to

https://www.microsoft.com/Licensing/servicecente

But it says key is not required. and they are two sp2.
Capture.JPG
0
 
LVL 70

Assisted Solution

by:Éric Moreau
Éric Moreau earned 50 total points
ID: 41845245
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)
0
Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

 

Author Comment

by:mcrmg
ID: 41845252
thanks for the clarification.
0
 
LVL 28

Accepted Solution

by:
Pawan Kumar earned 450 total points
ID: 41845293
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.

Pre-pidded
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?

--

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

--

Open in new window


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

For understanding the licensing you need to follow the URL -

https://www.microsoft.com/en-us/licensing/product-licensing/sql-server-2014.aspx

Hope it helps.
0
 

Author Comment

by:mcrmg
ID: 41845295
thank you. I will try that on Monday and post back.
0
 

Author Comment

by:mcrmg
ID: 41846726
I still have idea how the key was populated by itslef, lol, but it works...thanks
0
 

Author Closing Comment

by:mcrmg
ID: 41846729
thank you very much
0

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question