Solved

sql server liscensing

Posted on 2014-04-30
4
312 Views
Last Modified: 2014-05-15
Our DBA (which I am not btw) told me the other day that enterprise version of MSSQL come with "core" based liscensing? Does that mean that if you are running MSSQL enterprise edition then your liscensing model is always core based, or can you have enterprise MSSQL with CAL model liscensing?

Also if your MSSQL is in a cluster for HA, do you have to have consitency on liscensing model used on each instance on each node, or can you have a mix of liscence types on the same cluster?
0
Comment
Question by:pma111
  • 2
  • 2
4 Comments
 
LVL 24

Expert Comment

by:DBAduck - Ben Miller
ID: 40032161
SQL 2012 and above are all Core based licenses regardless of edition. That is the new licensing model for SQL Server.  There are grandfathering rules but only if you have SA or an Enterprise Agreement with Microsoft.

For licensing questions look here: http://download.microsoft.com/download/7/3/C/73CAD4E0-D0B5-4BE5-AB49-D5B886A5AE00/SQL_Server_2012_Licensing_Reference_Guide.pdf
0
 
LVL 3

Author Comment

by:pma111
ID: 40032478
But this is 2008
0
 
LVL 24

Accepted Solution

by:
DBAduck - Ben Miller earned 500 total points
ID: 40032488
Core based licensing began in SQL 2012.  So SQL 2008 has Server+CAL or Processor licenses.
0
 
LVL 3

Author Comment

by:pma111
ID: 40033988
Thanks dbaduck, when you buy a new SQL Server, what exactly do they give you? I know in older versions of MSSQL there were ways to query the MSSQL to determine which model was in operation, but not so in 2008. Having never been involved in such a purchase I just wondered what Microsoft or their partners give you in terms of a liscence purchase to show what you've bought?
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

733 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