What License do i choose?

Posted on 2006-06-05
Last Modified: 2008-03-10

Here is my scenario.  I will have a dedicated server. Only I will be developing the Database. It will be used for an ecommerce site, so I am forecasting a lot of concurrent users on the system.  I am confused based on my requirements what License I need.

I mean, what is the difference between

1. A single Processor License
2. A Few Client User License

My Confusion sets in when I think, do I need to accomodate for the amount of people who will be using the ecommerce site and thus indirectly using the Database?

Thanks in advance

Question by:REA_ANDREW
    LVL 50

    Assisted Solution

    AFAIK if you are connecting from the web the only valid licensing method is per processor...

    which version and edition of SQL Server are you contemplating using?

    LVL 20

    Author Comment

    I will be buying Sql Server 2005 Standard Edition.

    you see per processor is like £6000, where as the 5 License one is £599

    So I was hoping I only need the latter, as it was cheaper. Oh Well. Could you explain why I need the per processor?

    Is it due to concurrent connectionns and they CALs each one of them?
    LVL 27

    Expert Comment

    I agree with Lowfatspread - because you are using this on the web the best choice is Per Processor.
    LVL 20

    Author Comment

    "the best choice is Per Processor"

    Do you mean this is the only choice Leaglly or

    "the best choice is Per Processor" (What would be my other license choice)?

    LVL 27

    Accepted Solution

    CAL is based on the number of concurrent SQL connections. You would really have a dead web site if you did not allow more than 5 users (and you would have to kick off someone if you needed to work on it). Per Processor allows an unlimited number of connections and users.
    LVL 20

    Author Comment

    ahhhhhh, gotcha, thankyou.  That is what I was getting confused with, the CALS.  

    Great. :-)
    LVL 27

    Expert Comment

    From this link:

    Microsoft offers a processor-based licensing model to help
    alleviate complexity. Processor licenses can be used for any type
    of application (not limited to Web-based scenarios).
    Processor License – A Processor license is required for
    each processor installed on each server running SQL Server or any
    of its components (for example, Analysis Services). It includes
    access for an unlimited number of users or devices to connect
    from either inside or outside the firewall. Customers do not need
    to purchase additional Server Licenses or client access licenses
    Processor licenses are available in both Enterprise and Standard
    Editions and offer tremendous simplicity.

    Device CAL - A SQL Server Device CAL is required in order
    for a device (for example, a PC, workstation, terminal, PDA,
    mobile phone, and so on) to access or use the services or
    functionality of either edition of Microsoft SQL Server. The
    Server plus device CAL model will likely be the more costeffective
    choice if there are multiple users per device (for
    example, in a call center). Please see multiplexing section to
    ensure every device is licensed properly. The only exception is
    communication exclusively between SQL Servers.
    User CAL - A SQL Server User CAL is required in order for a
    user (employee, customer, partner, and so on) to access or utilize
    the services or functionality of either edition of Microsoft SQL
    Server. The Server plus user CAL model will likely be more cost
    effective if there are multiple devices per user (for example, a
    user who has a desktop PC, laptop, PDA, and so forth).
    A CAL is not software; it is a legal document granting a device
    or user access to server software. A single device CAL grants
    access to multiple servers for one device (CAL must be same
    version as latest version of any of the servers). A single user
    CAL grants access to multiple servers for one user (CAL must be
    same version as latest version of any of the servers).
    LVL 20

    Author Comment

    Just out of Interest, cause I cannot find the answer on the net.

    What is the concurrent user limit with Sql Server 2005 Express Edition?

    I only ask cause that is what we use currently for freelance work.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    737 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

    20 Experts available now in Live!

    Get 1:1 Help Now