Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


SQL Server 2012 license

Posted on 2014-02-21
Medium Priority
Last Modified: 2014-02-27
There are two copy of SQL 2012 server for download,

SQL Server 2012 standard Edition SP1 - Per Core
SQL Server 2012 standard edition SP1 - Server/CAL

What's the different between -Server and Per Core ? Tks
Question by:AXISHK
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
  • 3
  • 3
LVL 52

Expert Comment

by:Carl Tawn
ID: 39876279
With Server/CAL licensing you licence SQL Server to run on server, and buy CALs for each user who will access it. With the Core licencing model you licence SQL Server based on the number of cores on the machine (or VM) on which it will run - in this case you can have as many connections as you like and don't need to have CALs for individual users.

Which licencing model you need will depend on what you intend to do with it, and the number of users who will be accessing the SQL Server.

If you need Server/CAL licencing then there is a tipping point where it becomes cheaper to go with the Core model instead. Microsoft provide a calculator to help determine where that point is.

Author Comment

ID: 39876340
A server with 1 physical and 8 cores. Should i go for server liccnse or cores licenses.

LVL 52

Expert Comment

by:Carl Tawn
ID: 39876345
What are you planning to use the SQL Server for, and how many users will need to access it?
Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf


Author Comment

ID: 39876362
200 users
LVL 52

Assisted Solution

by:Carl Tawn
Carl Tawn earned 1000 total points
ID: 39876399
200 users puts you into the area where it might be cheaper to go with core licensing. You can find a simplified overview of the licencing models here:

But I would suggest you speak to Microsoft directly about your requirements as they are best placed to give you your options and specific dollar values of each.
LVL 27

Accepted Solution

Zberteoc earned 1000 total points
ID: 39876528

Author Closing Comment

ID: 39893614

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

660 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