Microsoft Defender for Cloud
Cloud and workloads

Verify SQL machine protection

In brief

The article now presents procedures for checking coverage across an Azure subscription or for an individual SQL server VM. It explicitly names the protection-status recommendation and troubleshooting guide, and reiterates that recommendation status refreshes every 12 hours.

What Defender admins need to know

Administrators can more easily locate the recommendation and troubleshooting steps when validating SQL Server on Machines coverage.

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.

After you enable Defender for SQL Servers on Machines, use this articlethe following verification procedures to verifyconfirm coverage for SQL Servers on Azure VMs, on-premises machines, and multicloud resources. You can check the protection status across an entire Azure subscription or verify a single SQL server VM or Azure Arc SQL Server instance.

Verify protection on an entire Azure subscription

Defender for Cloud presents The status of Microsoft SQL Servers on Machines should be protected recommendation. ThisThe The status of Microsoft SQL Servers on Machines should be protected recommendation allows you to review the protection status of Defender for SQL Servers on Machines. TheThis recommendation identifies all SQL VMs and Azure Arc SQL Server instances within a specified Azure subscription, and presents the protection status of each SQL Server instance.

  1. Sign in to the Azure portal.

  2. Select the unhealthy resource.

  3. Follow the troubleshooting guide steps in the Troubleshoot SQL machines protection guide, starting at Step 3: Identify and resolve protection misconfigurations at the SQL Server instance Level.

Defender for Cloud updates the The status of theMicrosoft SQL Servers on Machines should be protected recommendation every 12 hours. Follow the Troubleshoot SQL machines protection guide to fix each unprotected SQL server instance.

Verify protection on a single SQL server VM

  1. (Optional) Resolve the unprotected server instance status with the troubleshooting SQL Server on Machines guide.

Defender for Cloud updates the The status of theMicrosoft SQL Servers on Machines should be protected recommendation every 12 hours. Follow the Troubleshoot SQL machines protection guide to fix each unprotected SQL server instance.

Next step