question

AjayanPoorakkadavath-6174 avatar image
0 Votes"
AjayanPoorakkadavath-6174 asked OuryBa-MSFT edited

Azure SQL Audit status issue

Azure SQL Audit enabled at Server level but Azure SQL DBs shows that Server-level Auditing: Disabled. look like it is GUI issue.
SQL Server Audit configuration:
125675-server.jpg


SQL DB Audit configuration:
125716-db.jpg


azure-sql-database
server.jpg (94.6 KiB)
db.jpg (91.5 KiB)
· 1
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.

Hi @AjayanPoorakkadavath-6174 Thank you for posting your question on Microsoft Q&A. I tried to repo this issue on my end and also noticing the same thing. It may be a bug or something broke the GUI. I am working internally with our the Azure SQL team to find out more. I will give an update shortly.
Thank you for your patience.

Regards,
Oury

0 Votes 0 ·
SQLRockstar avatar image
0 Votes"
SQLRockstar answered

Auditing can be enabled at both levels - server and database. If you enable at the server level, it will be enabled for all databases. You can read more here, in the "Define server-level vs. database-level auditing policy" section. HTH


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.

OuryBa-MSFT avatar image
0 Votes"
OuryBa-MSFT answered OuryBa-MSFT edited

Hi @AjayanPoorakkadavath-6174
The portal only shows disabled, but in fact the SERVER AUDIT works just fine (and may actually be ENABLED).
At least it has been working for me since the “disabled” attribute was showing incorrectly on the portal.
If you run this in cloud shell:
Get-AzSqlServerAudit -ResourceGroupName <myResourceGroup> -ServerName <myServerName>


You can see the live – ENABLED server Audit.
125709-image.png

We are working with the Product Group to get the issue fix. Thank you for bringing this into our attention.
Regards,
Oury


image.png (132.7 KiB)
· 3
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.

Hi @AjayanPoorakkadavath-6174 This is a known issue and our Product Group is working for a fix. As a workaround , I will suggest to use Shell for now to verify whether auditing is enabled until this got resolved.

Regards,
Oury

0 Votes 0 ·

Hi @AjayanPoorakkadavath-6174 Our Product Group are actively working on this issue. I will notify you once a fix will be implemented.

Regards,
Oury

0 Votes 0 ·

Hi @AjayanPoorakkadavath-6174 Our Product Group has implemented a fix. Please check and let us know if it is working from your end.

132542-image.png

Regards,
Oury


0 Votes 0 ·
image.png (156.5 KiB)