Can't set storage account in Azure Defender for SQL: Vulnerability Assessment Settings

Eckert 116 Reputation points
2021-03-29T14:08:38.83+00:00

In the Azure Defender for SQL, under Vulnerability Assessment Settings, it will not let me set a storage account. I can choose my storage account, but when I try to save, the task just "spins" in the notification area, and then eventually fails. It give me the error: "Principal xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx does not exist in the directory xxxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx.

In the task details:

Operation name: Write RoleAssignments
Error code: PrincipalNotFound

Any suggestions?

Azure SQL Database
Microsoft Defender for Cloud
Microsoft Defender for Cloud
An Azure service that provides threat protection for workloads running in Azure, on-premises, and in other clouds. Previously known as Azure Security Center and Azure Defender.
1,194 questions
0 comments
Accepted answer
  1. Eckert 116 Reputation points
    2021-03-29T18:22:08.69+00:00

    I was able to update the storage account using azure powershell (Update-AzSqlServerVulnerabilityAssessmentSetting). The portal UI still doesn't work properly for me. It failed to save the "on" setting for Periodic scans. Unfortunately I cannot contact tech support in the Azure portal as this is a "technical" issue that my subscription doesn't cover.

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest