Issue:
The PowerShell command to enable Advanced Threat Protection on Managed Instance, fails with error: "Resource group 'x' could not be found":
Update-AzSqlServerAdvancedThreatProtectionSettings -ResourceGroupName "ResourceGroup11" -ServerName "Server01" -NotificationRecipientsEmails "admin01@contoso.com;secadmin@contoso.com" -EmailAdmins $False -ExcludedDetectionType "Sql_Injection_Vulnerability","SQL_Injection" -StorageAccountName "mystorageAccount"
Workaround:
If you are experiencing this issue, you can perform the following:
1. Set up the policy using ARM template:
or
2. Set up the policy using REST API:
Documentation:
Update-AzSqlServerAdvancedThreatProtectionSetting
Updated Jan 05, 2022
Version 1.0Georgiana_Pache
Microsoft
Joined September 11, 2020
Azure Database Support Blog
Follow this blog board to get notified when there's new activity