Forum Discussion

AzureBrian's avatar
AzureBrian
Copper Contributor
Dec 07, 2021

Invalid Managed Identity when running Vulnerability Assessment on Azure SQL Database

Greetings.  I'm hoping someone can shed some light on how to resolve an error I'm getting when running a scan on my Azure SQL Database from within the Azure portal.  I'm getting this line of output in the scan history:

 

 

However, I cannot find a managed identity for this functionality.  Maybe that's part of the problem, but I don't remember seeing one before either.  I guess what I'm struggling with most is where the managed identity would be set as I don't see any place in the UI to set this from Defender for Cloud's point-of-view.  I'm assuming the issue is with it writing the results to the storage account, yet the storage account settings appear to be configured correctly and allow Azure services to access.  Any thoughts on where to look to further triage this?  Any feedback would be most appreciated.  Thanks in advance

 

Brian

 

1 Reply

  • Avudaithangam's avatar
    Avudaithangam
    Copper Contributor
    I did the following to resolve the issue
    1. Enabled system assigned managed identity on Azure SQL server.
    2. On the azure storage account, assigned storage blob data contributor to the managed identity.

Resources