Solved

How MSSQL Server license works

Posted on 2013-06-20
4
361 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

Free Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

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…
Are client relationship the only driver of a successful MSP? While important, client relationships are only one component. Learn how else MSPs can broaden their horizon and differentiate themselves.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

749 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