Share via

Azure SQL Audit status issue

Ajayan Poorakkadavath 1 Reputation point
2021-08-23T16:29:34.527+00:00

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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Thomas LaRock 81 Reputation points
    2021-08-23T21:06:33.57+00:00

    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

    0 comments
  2. Oury Ba-MSFT 21,126 Reputation points Microsoft Employee Moderator
    2021-08-23T22:50:22.48+00:00

    Hi @Ajayan Poorakkadavath
    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

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.