Solved

How MSSQL Server license works

Posted on 2013-06-20
4
360 Views
Last Modified: 2013-07-05
Trying to determine how many CALs do I need for SQL license.  Do the users coming from the web count?  Or only direct connection.  
#2 does it count per processor or per core.  So if I have 2 CPU but 32 cores.  Do I need to pay per each core?
Useful links would be great.  Thanks.
0
Comment
Question by:Tiras25
  • 2
4 Comments
 
LVL 9

Assisted Solution

by:COANetwork
COANetwork earned 167 total points
ID: 39263776
SQL Server 2008 Licensing Overview
SQL Server 2012 Licensing Datasheet
SQL Server Licensing (forum thread)
Official MS SQL 2012 purchase page
Whether you are per-core or per-cpu depends on the edition.  for web connections - see the links above.  MS licensing is really convoluted
0
 
LVL 16

Assisted Solution

by:Surendra Nath
Surendra Nath earned 333 total points
ID: 39264026
For SQL 2008, they call it per socket.. that if you have one processor which has multiple cores ( in your case 32), still you need only one license.
But if you have two processors (physical processors) then you need two licenses.

Remember, the above is not true for SQL 2012 though, where they shifted from socket level licensing to core level license.
0
 
LVL 17

Author Comment

by:Tiras25
ID: 39264057
Ouch!  So with SQL2012 I would need 64 licenses if I have 32 cores per CPU.

So what determines CAL licenses?  Direct connectivity to the server or any client even over the web?
0
 
LVL 16

Accepted Solution

by:
Surendra Nath earned 333 total points
ID: 39264202
Any client who will access your application, it doesn't matter if it is direct connectvitiy or indirect connectivity.
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/2b4a718f-6089-4ce9-8d35-87f6a83b0335/sql-server-cal-licensing-as-it-applies-to-my-web-application

although the link is not working in this thread any more the info is true....

So, if you have more than 25 users, you have to for per processor licensing which costs around 2000 $
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Both MMF (multi-mode fiber) and SMF (single-mode fiber) are types of optical fiber that can aid in communication applications. These thin strands of silica or glass will allow communication to occur between devices. The transmission of light between…
Learn how ViaSat reduced average response times for IT incidents from 10 minutes to 30 seconds.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

860 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