locked
Licence 4 nodes Cluster SQL Enterprise Edition RRS feed

  • Question

  • I have 2 windows 2008 r2 server with a SQL failover cluster installed across 2 nodes ( SQL server Enterprise licence ).

    I 'd like to add 2 more servers on another site.

    In order to avoid buying licence which solution do I have to chose ?

    1) Implement a 4 nodes cluster ( active/passive/passive/passive) 

    2) Add another failover cluster that use mirroring in order to synchronise data between the 2 sites.

    Thank you

    Wednesday, April 18, 2012 10:09 AM

Answers

  • @chouchou2clichy

    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 the Guide to Worldwide Microsoft Licensing Sites to find contact information in your locations.


    Best Regards,
    Peja

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    • Marked as answer by Peja Tao Thursday, April 26, 2012 8:26 AM
    Thursday, April 19, 2012 2:25 AM
  • This topic is indeed quite complex and I can only follow Pejas suggestion to talk to MS directly. As far as I know the way it's done you only need to license servers that have the SQL Service effectively running and allowing connections... So in the case of a 4 node Active/Passive/Passive/Passive SQL failover cluster there should only be one needed. Once you start using features like AlwaysOn or even DB Mirroring it's a whole new ballgame though...

    Lucifer

    • Marked as answer by Peja Tao Thursday, April 26, 2012 8:26 AM
    Thursday, April 19, 2012 6:07 AM
  • I echo my comrades and suggest you should check your requirement with a licensing specialist however....

    If you implement option 2 and then use both servers for reads (or writes in the case of the principal) then you would need to license both instances. For example you could create a database snapshot on the Mirror to read from it. Or alternatively you might have several databases being mirrored in opposite directions. If you simply use the Mirror instance ONLY for DR and failover to it without needing to access the principal (and visa versa) then things should be good.

    Option 1 should be fine (for SQL licenses) but you'll still need to OS licenses.

    Anyway please ensure you do check with MS licensing for your solution.


    Regards,
    Mark Broadbent.

    Contact me through (twitter|blog)

    Please click "Propose As Answer" if a post solves your problem
    or "Vote As Helpful" if a post has been useful to you

    • Marked as answer by Peja Tao Thursday, April 26, 2012 8:26 AM
    Thursday, April 19, 2012 3:58 PM

All replies

  • I have my doubts about your options.... I think you will need to purchase two more licences. It is complicated (Licence Policy) so if you are lucky some one from MS will jump in to explain it in details.

    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

    Wednesday, April 18, 2012 10:38 AM
  • @chouchou2clichy

    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 the Guide to Worldwide Microsoft Licensing Sites to find contact information in your locations.


    Best Regards,
    Peja

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    • Marked as answer by Peja Tao Thursday, April 26, 2012 8:26 AM
    Thursday, April 19, 2012 2:25 AM
  • This topic is indeed quite complex and I can only follow Pejas suggestion to talk to MS directly. As far as I know the way it's done you only need to license servers that have the SQL Service effectively running and allowing connections... So in the case of a 4 node Active/Passive/Passive/Passive SQL failover cluster there should only be one needed. Once you start using features like AlwaysOn or even DB Mirroring it's a whole new ballgame though...

    Lucifer

    • Marked as answer by Peja Tao Thursday, April 26, 2012 8:26 AM
    Thursday, April 19, 2012 6:07 AM
  • I echo my comrades and suggest you should check your requirement with a licensing specialist however....

    If you implement option 2 and then use both servers for reads (or writes in the case of the principal) then you would need to license both instances. For example you could create a database snapshot on the Mirror to read from it. Or alternatively you might have several databases being mirrored in opposite directions. If you simply use the Mirror instance ONLY for DR and failover to it without needing to access the principal (and visa versa) then things should be good.

    Option 1 should be fine (for SQL licenses) but you'll still need to OS licenses.

    Anyway please ensure you do check with MS licensing for your solution.


    Regards,
    Mark Broadbent.

    Contact me through (twitter|blog)

    Please click "Propose As Answer" if a post solves your problem
    or "Vote As Helpful" if a post has been useful to you

    • Marked as answer by Peja Tao Thursday, April 26, 2012 8:26 AM
    Thursday, April 19, 2012 3:58 PM