?
Solved

Which one to download?

Posted on 2016-10-15
8
Medium Priority
?
77 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 200 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
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

Author Comment

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

Accepted Solution

by:
Pawan Kumar earned 1800 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

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

764 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