VM Extension with publisher 'Microsoft.SqlServer.Management' and type 'SqlIaaSAgent' does not support setting enableAutomaticUpgrade property to true on this subscription."

Question

Hi, I have tried to connect my Azure server and my Azure database to my python project. My python project uses a Tkinter GUI. I'm using both the Azure SQL database and the Azure VM in conjunction. The python app I have designed uses the Tkinter GUI. My goal was to connect the 2 Azure products to the desktop software I designed in order to host users of said python software. I used this link [https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/sql-vm-create-portal-quickstart?view=azuresql&tabs=conventional-vm to complete the process. When I finished configuring my VM I received an error code stating.

"message": "Operation cannot be completed due to the following error: VM Extension with publisher 'Microsoft.SqlServer.Management' and type 'SqlIaaSAgent' does not support setting enableAutomaticUpgrade property to true on this subscription."

How can I navigate around this in order to complete the task in creating the VM according to the instructions in the link sent to me? Screenshot (2).png Screenshot (8).png Screenshot (3).png Screenshot (7).png Screenshot (5).png

Kind regards

Colin Kimble

Answer 1

Hey,

We updated our ARM template to use the latest schema api version for Microsoft.SqlVirtualMachine/sqlVirtualMachines and registered Automatic Extension Upgrade Preview in the subscription based on [https://blog.hametbenoit.info/2021/02/17/azure-you-can-now-automatically-upgrade-the-extension-of-your-virtual-machine-preview/#.Y8aet3bMKUk

That fixed it for us.

Mateusz

Answer 2

This seems to help:

Register-AzProviderFeature -FeatureName AutomaticExtensionUpgradePreview -ProviderNamespace Microsoft.Compute

Get-AzProviderFeature -FeatureName AutomaticExtensionUpgradePreview -ProviderNamespace Microsoft.Compute

 

FeatureName                      ProviderName      RegistrationState
-----------                      ------------      -----------------
AutomaticExtensionUpgradePreview Microsoft.Compute Registered

Answer 3

I have the same issue at the moment. But the below responses from Jason & Matuesz helped me get this issue resolved. Its an extension which is in preview that is required to be registered.

Once you enter the below commands, your deployment will go without any issues.

Register-AzProviderFeature -FeatureName AutomaticExtensionUpgradePreview -ProviderNamespace Microsoft.Compute

Get-AzProviderFeature -FeatureName AutomaticExtensionUpgradePreview -ProviderNamespace Microsoft.Compute

 

FeatureName                      ProviderName      RegistrationState
-----------                      ------------      -----------------
AutomaticExtensionUpgradePreview Microsoft.Compute Registered

Thank you!

Answer 4

I've also noticed the same issue when trying to deploy a SQL VM via the portal. If I look in the ARM template that it generates, there's a setting called "enableAutomaticUpdates" which is different from "enableAutomaticUpgrade" mentioned in the error. Could be that there's something misaligned when the API to create the resource is called?

Answer 5

I have also got the same error, is that related to the subscription i have used both my prod & dev subscription but still face same issue. @Azure look into issue