How to update the SqlIaasExtension on Azure VM from lightweight mode to Full mode

Question

How to update the SqlIaasExtension on Azure VM from lightweight mode to Full mode

VJ-8370 651

Hi,

How to update the SqlIaasExtension on Azure VM from lightweight mode to Full mode.

Also, how and where can we see the mode of SqlIaasExtension on the Azure VM?

Regards,

VJ

Adithya Prasad K 1,375 Reputation points Microsoft External Staff Moderator

2025-05-09T09:37:46.0433333+00:00
Hi VJ-8370
it looks like you're trying to switch your SqlIaasExtension on an Azure VM from lightweight mode to full mode. Here’s how you can do that:

Delete the SQL IaaS Agent extension: Before switching to full mode, you need to remove the current extension. You can do this via the Azure portal, PowerShell, or Azure CLI. For PowerShell, you can use this command:
Remove-AzSqlVM -ResourceGroupName <resource_group_name> -Name <SQL_VM_resource_name>

Install the SQL IaaS Agent extension in full mode: After deleting the extension, you can register your VM with the SQL IaaS Agent extension in full mode. You will likely need the SQL Server installation media for the desired edition you want to run. You can run the command for Azure PowerShell or Azure CLI to register it again.

Confirm the registration: Once you've registered the SQL IaaS Agent extension in full mode, you can verify that it's successfully registered in the Azure portal. The extension's details should reflect it being in full mode.

To check the current mode of the SqlIaasExtension, you can simply go to the Azure portal:

Navigate to your SQL Server VM.

Under Settings, look for Extensions. You should see details about the currently installed SQL IaaS Agent extension including its mode.

I hope this helps! If you need more detailed steps or run into any issues, feel free to ask.
Adithya Prasad K 1,375 Reputation points Microsoft External Staff Moderator

2025-05-12T09:10:55.8466667+00:00

Hi VJ-8370
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Adithya Prasad K 1,375 Reputation points Microsoft External Staff Moderator

2025-05-13T09:48:14.1+00:00

Hi VJ-8370 We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
VJ-8370 651 Reputation points

2025-05-15T05:40:04.4633333+00:00

Thank you Adithya and Shraddha for your responses
Anonymous

2025-05-15T06:32:55.7166667+00:00

Hi VJ-8370, I wanted to follow up to see if my previous response was helpful. Please do not forget to click "Accept the answer” and Yes wherever the information provided helps you, this can be beneficial to other community members. Thank you

Accepted answer

0 additional answers

Your answer

Adithya Prasad K 1,375 Reputation points Microsoft External Staff Moderator

2025-05-09T09:37:46.0433333+00:00

Hi VJ-8370
it looks like you're trying to switch your SqlIaasExtension on an Azure VM from lightweight mode to full mode. Here’s how you can do that:

Delete the SQL IaaS Agent extension: Before switching to full mode, you need to remove the current extension. You can do this via the Azure portal, PowerShell, or Azure CLI. For PowerShell, you can use this command:
Remove-AzSqlVM -ResourceGroupName <resource_group_name> -Name <SQL_VM_resource_name>

Install the SQL IaaS Agent extension in full mode: After deleting the extension, you can register your VM with the SQL IaaS Agent extension in full mode. You will likely need the SQL Server installation media for the desired edition you want to run. You can run the command for Azure PowerShell or Azure CLI to register it again.

Confirm the registration: Once you've registered the SQL IaaS Agent extension in full mode, you can verify that it's successfully registered in the Azure portal. The extension's details should reflect it being in full mode.

To check the current mode of the SqlIaasExtension, you can simply go to the Azure portal:

Navigate to your SQL Server VM.

Under Settings, look for Extensions. You should see details about the currently installed SQL IaaS Agent extension including its mode.

I hope this helps! If you need more detailed steps or run into any issues, feel free to ask.
Adithya Prasad K 1,375 Reputation points Microsoft External Staff Moderator

2025-05-12T09:10:55.8466667+00:00

Hi VJ-8370
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Adithya Prasad K 1,375 Reputation points Microsoft External Staff Moderator

2025-05-13T09:48:14.1+00:00

Hi VJ-8370 We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
VJ-8370 651 Reputation points

2025-05-15T05:40:04.4633333+00:00

Thank you Adithya and Shraddha for your responses
Anonymous

2025-05-15T06:32:55.7166667+00:00

Hi VJ-8370, I wanted to follow up to see if my previous response was helpful. Please do not forget to click "Accept the answer” and Yes wherever the information provided helps you, this can be beneficial to other community members. Thank you

Answer 1

Hi VJ-8370, If your SQL IaaS Agent extension is in LightWeight mode and you want to switch to Full mode, Azure does not support direct in-place upgrades. Instead, you need to follow below steps:

Remove the Existing Lightweight Extension

Use the following PowerShell command to unregister the SQL VM from the SqlVirtualMachine resource provider and remove the Lightweight extension. Before switching modes, you need to remove the current Lightweight extension.


Remove-AzSqlVM -ResourceGroupName "<YourResourceGroup>" -Name "<YourSQLVMResourceName>"

Re-register the VM with SQL IaaS Extension in Full Mode

Now that the Lightweight mode is removed, you can re-register the VM with the extension in Full mode:


Set-AzSqlVM -ResourceGroupName "<YourResourceGroup>" -Name "<YourSQLVMResourceName>" -SqlManagementType Full

Verify the Extension Mode

You can verify the mode either from PowerShell or the Azure Portal


Get-AzSqlVM -ResourceGroupName "<YourResourceGroup>" -Name "<YourSQLVMResourceName>" | Select-Object SqlManagementType

To check the current mode of the SqlIaasExtension, you can simply go to the Azure portal:

Check the Mode in Azure Portal

Navigate to your SQL Server VM.

Under Settings, look for Extensions. You should see details about the currently installed SQL IaaS Agent extension including its mode.

Share via

How to update the SqlIaasExtension on Azure VM from lightweight mode to Full mode

0 additional answers

Your answer