Re: SQL Licensing--CALs

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Ron <fdskljfoiewiorewuokdvsfds@xxxxxxxxxxxxxxxxxxxxxxxx> wrote on
17 okt 2006 in microsoft.public.sqlserver.setup:

lucm@xxxxxxxxx wrote:
Scott Klein wrote:

I am trying to figure out what licensing I need for the
following scenario:

I have purchased an IIS application from a vendor that accesses
an MSSQL Standard database.

The vendor is saying I do not need CALs because the application
accesses the database using only 1 application ID. No users
will be accessing the database directly--only through the
application. A Senior Director refuses to sign off on this
because he's saying that we do need CALs based on the number of
users of the application.

Who's correct?

Thanks for your assistance.

SK


Your director is right. The SQL Server licensing is quite clear
about multi-tiered architectures. Here is the relevant part of
the "SQL Server 2005 Pricing and Licensing" document from
Microsoft:

"Sometimes organizations develop network scenarios that use
various forms of hardware and/or software that reduce the
number of devices or users that directly access or use the
software on a particular server, often called multiplexing or
pooling hardware or software. Use of such multiplexing or
pooling hardware and/or software does not reduce the number of
CALs required to access or use SQL Server software. A CAL is
required for each distinct device or user that is connected to
the multiplexing or pooling software or hardware front end.

Users / devices that access a SQL server indirectly require a
CAL. This is true no matter how many tiers of hardware or
software exist between the SQL Server and the client devices
that ultimately use its data, services or functionality."

If you don't know how many users you will have (which is common
with web applications), you need a per-processor license.

Regards,
lucm


I am in a similar situation too. Users connect to SQL server
using a web browser (IE), go to our website, login with their
username/password. On this site, they select search criterias
and submit the request. The apps then queries SQL in the back
end and spits out the result back to the users.

My boss doesn't want to get per-processor license. He wants to
have CALs instead (for example: purchase 10 CALs) so that only
10 users can connect at a time. The 11th user (and others) will
have to wait until someone disconnects.

It's my understanding that we can't successfully control user
connections thru SQL software or IIS software, am I right? With
1 CAL, we still can have unlimited number of users connected. I
know it's illegal. That's why I want to be able to control
connections to match the number of licenses we have.

Anyone know how to accomplish this? In addition to that, do we
need separate license for IIS connections?? Thanks in advance.

As I read the EULA, User CALs (and Device CALs) are *not* per
concurrent connection. So even if you manage to limit the number of
simultaneous queries to the SQL server to 10, you would still need
a CAL for every single user or device.
Seems to me that a per processor license is the only appropriate
solution.

_________________________________________________________
Vera Noest
MCSE, CCEA, Microsoft MVP - Terminal Server
SQL troubleshooting: http://sql.veranoest.net
___ please respond in newsgroup, NOT by private email ___
.

Relevant Pages

  • RE: licensing in SQL 2k
    ... Q. How do I license SQL Server 2000? ... Server plus device CALs. ... Per User CALs - Use this CALs option, if the same user would be connecting ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Licensing--CALs
    ... My boss doesn't want to get per-processor license. ... have CALs instead so that only ... It's my understanding that we can't successfully control user connections thru SQL software or IIS software, ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server License Control and Management
    ... license, and than match it to my HR system. ... If user is an employee I ... Like I said, CALs ... David Portas, SQL Server MVP ...
    (comp.databases.ms-sqlserver)
  • Re: SQL Licensing
    ... You need 25 CALs, or if you are running Standard Edition, you might as well ... It's the end users/devices that count for the license, ... SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: SharePoint (not Portal) Licensing
    ... Windows Svr Cals for each device or user accessing the server. ... customer is running Sharepoint Servcies with SQL server, ... also need SQL Svr license and each device or user would also need a SQL CAL. ...
    (microsoft.public.sharepoint.windowsservices)