question

Eckert-6402 avatar image
0 Votes"
Eckert-6402 asked Eckert-6402 answered

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

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-databaseazure-security-center
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Eckert-6402 avatar image
0 Votes"
Eckert-6402 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.