In-place change of SQL Server edition on Azure VM
This article describes how to change the edition of SQL Server on a Windows virtual machine in Azure.
The edition of SQL Server is determined by the product key, and is specified during the installation process using the installation media. The edition dictates what features are available in the SQL Server product. You can change the SQL Server edition with the installation media and either downgrade to reduce cost or upgrade to enable more features.
Once the edition of SQL Server has been changed internally to the SQL Server VM, you must then update the edition property of SQL Server in the Azure portal for billing purposes.
To do an in-place change of the edition of SQL Server, you need the following:
- An Azure subscription.
- A SQL Server VM on Windows registered with the SQL IaaS Agent extension.
- Setup media with the desired edition of SQL Server. Customers who have Software Assurance can obtain their installation media from the Volume Licensing Center. Customers who don't have Software Assurance can use the setup media from an Azure Marketplace SQL Server VM image that has their desired edition (typically located in
Upgrade an edition
Upgrading the edition of SQL Server will restart the service for SQL Server, along with any associated services, such as Analysis Services and R Services.
To upgrade the edition of SQL Server, obtain the SQL Server setup media for the desired edition of SQL Server, and then do the following:
Open Setup.exe from the SQL Server installation media.
Go to Maintenance and choose the Edition Upgrade option.
Select Next until you reach the Ready to upgrade edition page, and then select Upgrade. The setup window might stop responding for a few minutes while the change is taking effect. A Complete page will confirm that your edition upgrade is finished.
After the SQL Server edition is upgraded, modify the edition property of the SQL Server virtual machine in the Azure portal. This will update the metadata and billing associated with this VM.
Downgrade an edition
To downgrade the edition of SQL Server, you need to completely uninstall SQL Server, and reinstall it again with the desired edition setup media.
Uninstalling SQL Server might incur additional downtime.
You can downgrade the edition of SQL Server by following these steps:
- Back up all databases, including the system databases.
- Move system databases (master, model, and msdb) to a new location.
- Completely uninstall SQL Server and all associated services.
- Restart the virtual machine.
- Install SQL Server by using the media with the desired edition of SQL Server.
- Install the latest service packs and cumulative updates.
- Replace the new system databases that were created during installation with the system databases that you previously moved to a different location.
After the SQL Server edition is downgraded, modify the edition property of the SQL Server virtual machine in the Azure portal. This will update the metadata and billing associated with this VM.
Change edition in portal
Once you've changed the edition of SQL Server using the installation media, and you've registered your SQL Server VM with the SQL IaaS Agent extension, you can then use the Azure portal to modify the Edition property of the SQL Server VM for billing purposes. To do so, follow these steps:
Sign in to the Azure portal.
Go to your SQL Server virtual machine resource.
Under Settings, select Configure. Then select your desired edition of SQL Server from the drop-down list under Edition.
Review the warning that says you must change the SQL Server edition first, and that the edition property must match the SQL Server edition.
Select Apply to apply your edition metadata changes.
- The edition property for the SQL Server VM must match the edition of the SQL Server instance installed for all SQL Server virtual machines, including both pay-as-you-go and bring-your-own-license types of licenses.
- If you drop your SQL Server VM resource, you will go back to the hard-coded edition setting of the image.
- The ability to change the edition is a feature of the SQL IaaS Agent extension. Deploying an Azure Marketplace image through the Azure portal automatically registers a SQL Server VM with the SQL IaaS Agent extension. However, customers who are self-installing SQL Server will need to manually register their SQL Server VM.
- Adding a SQL Server VM to an availability set requires re-creating the VM. Any VMs added to an availability set will go back to the default edition, and the edition will need to be modified again.
For more information, see the following articles: