locked
SQL Failover with OEM license RRS feed

  • Question

  • Hi.
    I am trying to figure out how to Setup a 2 node active/passive failover with windows severstandard and SQL server standard. I want one node ready to take over if the other fails or is taken down for maintainance
    I have found this:
     
    • SQL Server Standard 2017 allows high availability through the feature called AlwaysOn.
    • AlwaysOn allows customers to have an active / passive instances meaning that SQL Server can have a secondary (cold installation), to recover data from in case of a disaster or hardware failure on the primary server.
    • The licensing of AlwaysOn scenario requires a SQL Server license on the primary server and a Software Assurance coverage to be able to install a passive instance on the secondary server.
    • AlwaysOn feature on SQL Server Standard is limited to 2 nodes (active/passive instances)


      However It seems tthat software assurance is not avaible for OEM licensing? So am I out of look?
    Friday, July 31, 2020 12:44 PM

All replies

  • For detailed information about 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 https://www.microsoft.com/en-us/licensing/worldwide to find contact information in your locations.
    • Proposed as answer by MIAOYUXI Monday, August 3, 2020 6:51 AM
    Friday, July 31, 2020 12:58 PM
  • Hi GustavAB,

    >However It seems tthat software assurance is not avaible for OEM licensing? So am I out of look?

    I think you are right.

    However I am not sure becuase I am not one expert on license issue. You can fistly google it by typing “sqlserver 2017 license guide” to download the PDF and  have a look, and then for your own situation, you need to consult the license team to get a guide for purchasing.


    License Team:For detailed information about 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 licensing_worldwide to find contact information in your locations. Or you can go to Volume Licensing Service Center supportPlease choose region/language and choose to call or have web. People there will help you more effectively.

    BR,

    Mia



    • Edited by MIAOYUXI Monday, August 3, 2020 6:55 AM
    Monday, August 3, 2020 6:54 AM
  • Hi GustavAB,

    Is the reply helpful?

    BR,

    Mia

    Tuesday, August 4, 2020 12:36 AM
  • Hi GustavAB,

    Is the reply helpful?

    BR,

    Mia


    ""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
    We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
    For more information, please refer to the sticky post.

    Wednesday, August 5, 2020 1:13 AM
  • Hi GustavAB,

    Is your issue solved?

    Is the reply helpful?

    If the response helped, do "Accept Answer" and upvote it.

    BR,

    Mia


    ""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
    We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
    For more information, please refer to the sticky post.

    Thursday, August 6, 2020 1:17 AM

    • The licensing of AlwaysOn scenario requires a SQL Server license on the primary server and a Software Assurance coverage to be able to install a passive instance on the secondary server.

    Allow me to correct few things. 

    1. SA is required, or as a fact should be taken so that you dont have to pay for cores SQL Server is using on secondary replica as long as it is NON READABLE secondary replica. If no SA purchased, you would  have to pay for cores of secondary replica . A good read 

    New high availability and disaster recovery benefits for SQL Server

    • SQL Server Standard 2017 allows high availability through the feature called AlwaysOn.
    • However It seems tthat software assurance is not avaible for OEM licensing? So am I out of look?

    To be more correct it is called Basic Availability groups. Their is no term as AlwaysOn the correct term is Availability groups.

    Reg OEM license quoting it from FAQ( Type "software assurance on oem license" in google and see the first PDF

    Can I add Software Assurance to an OEM/Retail product license?

    Yes, you can attach standalone Software Assurance coverage to an OEM/Retail product license, but you must do so within 90 days of purchasing the OEM/Retail (full packaged product) product license. This option is available only for particular products through particular Volume Licensing programs. For details, see the Microsoft Product Terms.

    If I attach Software Assurance to an OEM/Retail product license within 90 days, which use rights apply?

    If you acquire Software Assurance for an OEM/Retail (full packaged product) product license within 90 days of purchase, you gain the option of installing and using the Volume Licensing software version


    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Thursday, August 6, 2020 3:53 PM