SQL 2016 on Windows 2012 R2 RRS feed

  • Question

  • I'm looking for an machine image for SQL server 2016 (standard preferably) running on Windows 2012 R2. I can only find the BYOL Enterprise one.

    I see 2012 and 2014 on Windows 2012. Would we be allowed to deploy one of those templates and upgrade SQL to 2016?

    Or do we have to deploy just a Windows 2012 machine image and BYOL our own license and software for SQL?

    Thank you,

    Tuesday, February 21, 2017 7:23 PM


  • The last option should be feasible in your case since there is no image in the Azure gallery which offers SQL Server 2016 BYOL on Windows Server 2016. You will have to bring your on-premise SQL 2016 license to the Windows 2012 Azure VM. However, you need to have License Mobility through Software Assurance on Azure for dong this.

    Currently, there is no in-place upgrade for SQL Server running in an Azure VM. You will have to create a new Azure virtual machine with the desired SQL Server version/edition. SQL Server on Azure Virtual Machines FAQ should help answer any further questions on the licensing and the configuration part for you. As per Hardware and Software Requirements for Installing SQL Server, SQL 2016 can be setup on a Windows Server 2012 OS image. It is just that the SQL 2016 standard on Windows Server 2012 R2 is not available in the Azure gallery at the moment.

    Wednesday, February 22, 2017 10:28 AM