Question about SQL License RRS feed

  • Question

  • Why using a IIS and backend SQL Server do we have to pay per user or per core?

    Lets talk about it from the technical perspective.
    1. IIS is using Anonymous user and this access has been licensed throug Windows Server, and the user has alraedy paid for it
    2. The condition for apply a license x user is when the local account , an Active Directory or any Application Rol is the principal authenticator and authorizator. So, in this perspective if the user has been validated for any other method, that method is not part of SQL structure but the intelectual from that developer.

    Where can we see this scenario on a Tech Document from Microsoft, where specifically  this use case has been treated?
    It does not exist. So my question is. If this scenario does not have any clarification, and in addition is not include  in any product contracts, Why the License auditors and Microsoft have to force the final user to pay for somethis that is not part of Microsoft? . We have to interpret this scenario like your strategy to force people to migrate to Azure. This scenario is not ilegal?


    Saturday, January 20, 2018 8:25 PM


All replies

  • HI Anderson,

    as per your query what i get is "if someone is using IIS to connect SQL which is through one (anonymous) user then sql server should be licensed as Server+1 cal license" right?

    in that case this is termed as multiplexing where N users are going to indirectly access data of SQL using IIS based application. This term is available in SQL 2012 Licensing Guide.

    Still i suggest you to contact your license vendor and ask for detailed explanation on licenses based on your peculiar requirement. Any suggestion on forum may differ in license requirement due to  understanding and result in non compliance.  


    AKash Pawar

    Sunday, January 21, 2018 6:03 AM
  • Hello,

    This is a community forum for technical questions & issues.

    For question regarding pricing / licensing please contact a Microsoft sales partner or licensing expert.
    Call (1-800-426-9400), Monday through Friday, 6:00 AM to 6:00 PM PST to speak directly to Microsoft licensing specialist.

    Why using a IIS and backend SQL Server do we have to pay per user or per core?

    That's called "Multiplexer Scenario", see licenses guide.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Marked as answer by Olaf HelperMVP Saturday, February 3, 2018 6:15 AM
    Monday, January 22, 2018 6:42 PM
  • Licensing questions should be asked to the MS Licensing Department.

    However, the "Licensing Guide" specifies your situation as "multiplexed application environment".

    Please see:


    • Marked as answer by Olaf HelperMVP Saturday, February 3, 2018 6:15 AM
    Monday, January 22, 2018 6:53 PM
  • Hi.
    Thank you for the response, however, one thing is a basic Web services with no other thing that open a port,  another one this concept call multiplexed applications.
    IIS is a Multithread and multitenant service, is not a component of multiplexed applications. Be aware that i am not talking about your new policies, we are talking about applications fundamentals and correct technology concepts.

    Products like, Kubernetes, Coreos , Dockers and containers are capable of running Multiplexed application, and IIS is far from this scenario. A multiplexed application must to have more components, for instance: A rol application at least totally integraded with web server rol, orchestration, with contenainerized components with authentication and  authorization within a Microsoft product or through services built in a suite development Microsoft product.

    The botton line, IIS in my use case behaves like  a basic service, in his feautres a web servers is to allow to the user be a able to connect independent of the method, and independent of sessions number. It is tru that in networking scenarios we can run several devices and reroute many user for only one device or many of them, but  we are talking of IIS like a multitenant product, has been licensed through Windows Server,and the user has paid for it, that is the difference. In addition his purpose by his basis fundamentals is a public service, and must remain with this behavior.

    In other words, you can not run multiplexed applications with IIS by design in my use case. I know you call thus this, but it is needed other components IIS do not have in his core design.

    The point is that, The license schema for SQL Server with IIS is not sounding and not so good in the market for a Developers ecosystem. I think this is closing many oportunity for Microsoft partners and motivate  developers consider other options like google.

    Think about it, because developers and integrators like me, drop off a brand vendor of our heart fast, for our convenience.

    Thank you


    Saturday, January 27, 2018 2:37 PM
  • While I agree with you, and have argued the same, MS does not agree.  MS is free to create any pricing and licensing it wants.  MS created this licensing model over 10 years ago and has not wavered.

    Tuesday, January 30, 2018 11:54 AM