Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 352
  • Last Modified:

sql server liscensing

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
pma111
Asked:
pma111
  • 2
  • 2
1 Solution
 
DBAduck - Ben MillerPrincipal ConsultantCommented:
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
 
pma111Author Commented:
But this is 2008
0
 
DBAduck - Ben MillerPrincipal ConsultantCommented:
Core based licensing began in SQL 2012.  So SQL 2008 has Server+CAL or Processor licenses.
0
 
pma111Author Commented:
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now