March 9, 2008 at 6:00 am
can any body please tell as to when we need to use "Server/CAL",or client cal or per[ processor license.?
why is it said incase of internet we need to use processor license?....
if i have an application all the user name and password are located in a sql server table. a user conenct to the the d/b and the authentication is done by verifying its credentials absed on the table tht ia present in sql server....in this case why do i need to go for processor licenseing?......since all the users connecting will be using one application password to get thru the main d/b and then authencicated internally
thanks for the help.
March 9, 2008 at 2:31 pm
Sharon, CAL licensing is based on the number of concurrent connections to the SQL server, what id theese users use to connect is not relevant, all that matters is the number of them.processor licensing you pay a set fee based on the no of processors on the sql server. (physical cpus only, a 4 core cpu = only one processor license)
You tend to use per processor licensing with internet based apps because you obviously have the possibility of hundreds of users connecting, and in that case the per processor licensing model tends to be cheaper.
A single CAL license is much cheaper but there will be a cross over point once the no. of users ramps up, you need to work out which will be cheaper for you depending on the usage of your server
---------------------------------------------------------------------
March 9, 2008 at 5:03 pm
In addition to the previous post I believe that CAL licensing has to be done in a minimum of a block of 5.
One CAL is used by the server itself so you only really have 4 licenses available.
March 9, 2008 at 8:31 pm
sharon (3/9/2008)
can any body please tell as to when we need to use "Server/CAL",or client cal or per[ processor license.?why is it said incase of internet we need to use processor license?....
if i have an application all the user name and password are located in a sql server table. a user conenct to the the d/b and the authentication is done by verifying its credentials absed on the table tht ia present in sql server....in this case why do i need to go for processor licenseing?......since all the users connecting will be using one application password to get thru the main d/b and then authencicated internally
thanks for the help.
SQL Licensing is based on "direct and indirect" users. Meaning - it doesn't matter that the users are accessing it directly or not - if they're accessing an app that access SQL server - they're a user.
The equation for determining cost-effectiveness of Processor licensing versus CAL is supposed to be 25-1 for standard, and 75-1 for enterprise. Meaning - on a 4 processor machine - getting 100 CAL's of Standard should be just about the same as buying the 4-processor version.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply