none
do we need a license for a second instance

    Question

  • Hi,

    do we need to license a second instance in scenario:

    SQL 2016 is installed and licensed per core.

    SQL 2012 instance added.

    Both instances are running the same language.

    This is quick googling. Can somebody help to interpret? 

    https://msdn.microsoft.com/en-us/library/ms143522%28v=sql.120%29.aspx?f=255&MSPPError=-2147217396


    SQL Server 2014
     

    The Microsoft Software License Terms are copied to the local computer when SQL Server is installed. When multiple instances of the same edition and language of SQL Server are installed on the same computer, a single copy of the license terms will apply to all instances of that edition and language. The files are written to: %ProgramFiles%\MicrosoftSQL Server\120\License Terms\ or %ProgramFiles(x86)%\ MicrosoftSQL Server\120\License Terms\.

    When multiple instances of the same SQL Server edition and language are installed on the same computer, a single copy of the license terms will apply to all instances of that edition and language.

    The license terms file name indicates the edition of SQL Server as well as the SQL Server language edition that is installed. The License terms file name is in the format: SQLServer2014_License_Edition_<TYPE>_<LCID>.rtf. For example:

    • SQLServer2014_License_DEV_1033.rtf for SQL Server 2014 Developer, English language edition.

    • SQLServer2014_License_EXPR_1033.rtf for SQL Server 2014 Express, English language edition.

    TYPE indicates the SQL Server edition. The following file name segments are used to identify SQL Server editions:

    • ENT – Enterprise Edition: Server/Client Access License (CAL) Licensing

    • ENTCORE – Enterprise Edition: Core-based Licensing

    • BI – Business Intelligence

    • DEV – Developer

    • STD – Standard

    • WEB – Web

    • EXPR – Express


    --- When you hit a wrong note its the next note that makes it good or bad. --- Miles Davis

    Thursday, February 23, 2017 10:29 PM

All replies

  • This is really a technical forum, and not the best place to get licensing questions answered.

    With that said, do a search on the web for "Microsoft volume license PUR" and you will find the "Product Use Rights" document that explains how all licensing works. In that document I'm sure you'll find that in your particular case, SQL is licensed by the cores in the OS, so once an OS is licensed for SQL, you can install additional instances ( of the same SQL SKU ) with no need for additional licenses.

    Mike J


    MJ

    • Proposed as answer by Mike Jenne Thursday, February 23, 2017 10:58 PM
    Thursday, February 23, 2017 10:58 PM
  • Mike, I know that it is technical forum. Use it for years with great pleasure. 

    Thanks.




    --- When you hit a wrong note its the next note that makes it good or bad. --- Miles Davis

    Friday, February 24, 2017 1:24 AM
  • Hi pob579,

    The link you provided discuss where the license term(in file) located on the machine that hosts SQL Server, not the license term itself. 

    In your case you should talk to a licensing specialist for confirmation. For more detailed information regarding to the license issue, please call 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist. For international customers, please use Worldwide Microsoft Licensing Sites to find contact information in your locations.

    If you have any other questions, please let me know.

    Regards,
    Lin

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Proposed as answer by Shanky_621MVP, Moderator Friday, February 24, 2017 7:13 AM
    • Marked as answer by pob579 Friday, February 24, 2017 12:06 PM
    • Unmarked as answer by pob579 Saturday, February 25, 2017 2:22 AM
    Friday, February 24, 2017 6:42 AM
    Moderator
  • Thanks.

    --- When you hit a wrong note its the next note that makes it good or bad. --- Miles Davis

    Friday, February 24, 2017 12:06 PM
  • Lin,

    just to be clear...  I provided Microsoft link because I think that the "KEY" line there, is:

    "When multiple instances of the same SQL Server edition and language are installed on the same computer, a single copy of the license terms will apply to all instances of that edition and language."

    And from this :

    " a single copy of the license terms will apply to all instances of that edition and language."

    the language  and edition are mentioned : Both instances should be: Standard, Ent or Dev and language for example Eng.

    What is not mentioned  is: could they be 2012, 2014 and 2016.

    When asked the question, I thought that somebody could have the installation similar to what I asked. Sure that there are people using 2 and more instances...

    I sent a question to Microsoft Licensing. The answer should come in 48 hours. I will post it here.

    Don't think that it is my super particular question. It is really general question that should apply  to everyone (sure I can be wrong :)).


    --- When you hit a wrong note its the next note that makes it good or bad. --- Miles Davis


    • Edited by pob579 Saturday, February 25, 2017 9:32 PM
    Saturday, February 25, 2017 9:31 PM