SQL Server Licensing uestion

Posted on 2010-01-07
Last Modified: 2013-11-25
I understand there are two types of licensing. The CPU and CAL.
With the first one it doesn't matter how many computers will be clients to the server, but in the secont wuth buy a license for all the clients.
Let's say I don't use a WEB application, but a Windows app, that has a server and for example 50 clients. And all the clients have local DBes. What happens then? I buy 51 licenses? Considering one licens is 6000$ thats unthinkable. Explain pls.
Question by:IncognitoMan
    LVL 7

    Expert Comment

    If you want to run SQL Server on 50 clients perhaps you should get the Express Edition.  Although I must say I am intrigued as to why each client needs its own local database if you don't mind me asking.

    Here is a link for SQL Server 2005 Express.  The 2008 version is available from this link as well.



    Author Comment

    The idea is, that if the connection to th server fails, the system for this client will not work. SO every PC need to have its own local DB if it's impossible to be always connected. Express editions are not a good solution.
    Look at the limitations.
    What if the DB becomes larger than 4 GB? So tell me do I have to pay 51 licenses?
    LVL 75

    Accepted Solution

    >>So tell me do I have to pay 51 licenses?<<
    In your scenario, if you are going to install SQL Server on each box than the answer is yes.

    Author Comment

    Thank you acperkins. Is there a cheaper solution, that includes local databases?
    LVL 75

    Expert Comment

    by:Anthony Perkins
    If you cannot use SQL Server Express, consider something like MySQL instead of MS SQL Server.  

    Author Comment

    acperkins, I am asking because I want to understand if SQL Server can be applied to this kind of systems. The answer is no. Than you for your help.

    Author Closing Comment

    You answered to this question right. Thank you.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Error message when scheduling a job using a linked Server 12 40
    SQL help 5 42
    sql help 5 42
    How to query LOCK_ESCALATION 4 22
    In Agile (, time and again people ask this question "How would you estimate a release for a product?". When it comes from management they want to know the following: Calculate the man hours wh…
    In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    730 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

    15 Experts available now in Live!

    Get 1:1 Help Now