Solved

How MSSQL Server license works

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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Scenario: Your operations manager has discovered an anomaly in your security system. The business will start to suffer within 15 minutes if it is a major IT incident. What should she do? We have 6 recommendations for managing major incidents (https:…
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.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

910 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now