Migrate to Defender for SQL on machines using AMA

Microsoft Monitoring Agent (MMA) is being deprecated in August 2024. As a result, a new SQL server-targeted Azure Monitoring Agent (AMA) autoprovisioning process was released. You can learn more about the Defender for SQL Server on machines Log Analytics Agent's deprecation plan.

Customers who are using the current Log Analytics agent/Azure Monitor agent autoprovisioning process, should migrate to the new Azure Monitoring Agent for SQL server on machines autoprovisioning process. The migration process is seamless and provides continuous protection for all machines.

Migrate to the SQL server-targeted AMA autoprovisioning process

1. Sign in to the Azure portal.

2. Search for and select Microsoft Defender for Cloud.

3. In the Defender for Cloud menu, select Environment settings.

4. Select the relevant subscription.

5. Under the Databases plan, select Action required.

   Note

   If you do not see the action required button, under the Databases plan select Settings and then toggle the Azure Monitoring Agent for SQL server on machines option to On. Then select Continue > Save.

6. In the pop-up window, select Enable.

   

7. Select Save.

Once the SQL server-targeted AMA autoprovisioning process has been enabled, you should disable the Log Analytics agent/Azure Monitor agent autoprovisioning process.

Note

If you have the Defender for Server plan enabled, you will need to review the Defender for Servers Log Analytics deprecation plan for Log Analytics agent/Azure Monitor agent dependency before disabling the process.

Disable the Log Analytics agent/Azure Monitor agent

1. Sign in to the Azure portal.

2. Search for and select Microsoft Defender for Cloud.

3. In the Defender for Cloud menu, select Environment settings.

4. Select the relevant subscription.

5. Under the Database plan, select Settings.

6. Toggle the Log Analytics agent/Azure Monitor agent to Off.

   

7. Select Continue.

8. Select Save.

Next steps

For related information, see these resources:

• How Microsoft Defender for Azure SQL can protect SQL servers anywhere.
• Security alerts for SQL Database and Azure Synapse Analytics
• Set up email notifications for security alerts
• Check out common questions about Defender for Databases.