I have setup an Diagnostic setting for an SQL Database to achieve SQL Security Audit Event log into storage account but not able to see any container related to SQL Security Audit Event . Am I missing some configuration or setting? Need help regarding the same.

You will have to configure Auditing for SQL DB from Auditing page at DB or Server level. From Diag, it's not supported. https://learn.microsoft.com/en-us/azure/azure-monitor/essentials/diagnostic-settings

Not seeing any SQL Security Audit Event on storage account even after configuring Diagnostic setting

Ashish Tiwari 0

I have setup an Diagnostic setting for an SQL Database to achieve SQL Security Audit Event log into storage account User's image

but not able to see any container related to SQL Security Audit Event. User's image

Am I missing some configuration or setting? Need help regarding the same.

GeethaThatipatri-MSFT 29,377 Reputation points Microsoft Employee

2024-08-28T00:22:07.51+00:00

@Ashish Tiwari Thanks for posting your question in the Microsoft Q&A forum.

Here is the blog which can help you to fix your issue.

https://techcommunity.microsoft.com/t5/azure-database-support-blog/azure-sql-database-auditing-not-writing-to-storage-account/ba-p/1813153

Regards

Geetha

1 answer

Nandan Hegde 32,026 Reputation points MVP

2024-08-28T07:41:18.7433333+00:00

You will have to configure Auditing for SQL DB from Auditing page at DB or Server level. From Diag, it's not supported.

https://learn.microsoft.com/en-us/azure/azure-monitor/essentials/diagnostic-settings
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Not seeing any SQL Security Audit Event on storage account even after configuring Diagnostic setting

1 answer

Your answer