Microsoft Defender for Cloud
Cloud and workloads

Verify Defender for SQL Servers on Machines protection for SQL VMs in government clouds

In brief

The article now covers verification across Azure VMs, Azure Arc-enabled VMs, and individual SQL server VMs. It adds an Azure Resource Graph query for finding unprotected Arc-enabled VMs and clarifies the Azure portal checks for protection status.

What Defender admins need to know

Administrators have clearer steps to identify and confirm protection issues across government-cloud environments.

Summaries are generated from the documentation change itself.

Documentation change

The comparison below shows only the changed extract. Use the full-page view for complete context.

Verify SQL machine protection governmentin Azure Government

After enabling protection for SQL VMs with the Defender for SQL Servers on Machines plan, verify that your SQL servers are protected as expected. This article shows how to check protection status across multiple Azure VMs, Azure Arc-enabled VMs, and individual SQL server VMs in government cloud environments.

Verify protection on multiple Azure VMs

Verify protection on multiple Azure Arc-enabled VMs

To verify protection status across multiple Azure Arc-enabled VMs, run the following query in Azure Resource Graph to identify unprotected instances.

  1. In the Azure portal, Search for and select Azure Resource Graph.

  2. Copy and run the following query to identify Azure Arc-enabled VMs that aren't in a protected state.

    :::image type="content" source="media/verify-machines-protection-gov/script-results.png" alt-text="Screenshot of the results screen once the script runs." lightbox="media/verify-machines-protection-gov/script-results.png":::

  3. If the ProtectionStatusLastUpdate field doesn't show a date within the last day, the machine might not be protected. To confirm, verify the protection on a single SQL server VM. by checking its Protection status under Security > Defender for Cloud in the Azure portal.

    :::image type="content" source="media/verify-machines-protection-gov/status-update.png" alt-text="Screenshot that shows the last status update for the SQL instance." lightbox="media/verify-machines-protection-gov/status-update.png":::

Verify protection on a single SQL server VM

To verify protection for a single SQL server VM, perform the following steps in the Azure portal.

  1. Depending on the resources in your environment, search for and select SQL virtual machines or SQL Server - Azure Arc in the Azure portal.

  2. Locate and select the relevant resource.

Troubleshoot unprotected machines

If databases aren't protected, follow the instructions in the Troubleshoot SQL machine protection issues to remediate the issues.