defender for cloud scans against azure sql not updating for all databases

Question

Hello, i have an Azure SQL server with 5 databases.
when working in Microsoft Defender for cloud,I am trying to work on the vulnerabilities,
I can see the results for 3 of the databases but the other 2 keep giving me errors of
"SQL vulnerability assessment results are not available yet"
I can click the scan button and it says it ran but the results never show.
last scan time is showing as 31/12/1, 23:58:45 (UTC) for both databases.

Any ideas how i can fix this?
Thank you

Answer 1

Hi @Dwyer, Brian (Premier Farnell)

Thanks for the Question and using microsoft Q&A

As per my understanding you're encountering an issue with Defender for Cloud not updating the vulnerability assessment results for two of your Azure SQL databases.

Here are a few steps you can try to resolve this issue:

• Ensure that Microsoft Defender for Cloud is correctly configured for all five databases. Sometimes, certain databases might not have the same policies applied, which could cause discrepancies in the vulnerability assessment results.
• Make sure that you have the proper permissions to view the vulnerability assessment results. You’ll need at least Security Reader or Contributor access at the resource or subscription level. Insufficient permissions could prevent the results from appearing.
• Try running an on-demand vulnerability assessment scan for the affected databases.
• Sometimes clearing your browser cache or using a different browser can help refresh the results.
• If the issue continues, you might want to contact Microsoft Support for additional help.

Please go through these Documentations that might help you:

https://learn.microsoft.com/en-us/azure/defender-for-cloud/sql-azure-vulnerability-assessment-enable

https://learn.microsoft.com/en-us/azure/defender-for-cloud/sql-azure-vulnerability-assessment-manage

Hope this helps. Do let us know if you any further queries. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.