Enable auditing on sql server via Azure ARM template

Nandhini Anand 21 Reputation points
2022-02-27T14:51:35.377+00:00

Hi Team,

I am trying to enable sql audit settings on azure sql server. I want to audit logs to be stored in log analytics.

I do not want to enable auditing for the sql database though.

Please share the script to enable the audit on sql server and set the destination to log analytics workspace

Thanks!

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,897 questions
0 comments No comments
{count} votes

Accepted answer
  1. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2022-02-28T02:29:21.323+00:00

    Hi NandhiniAnand-4146,

    Welcome to Microsoft Q&A.
    Please check the following tutorials which might be helpful:
    Auditing for Azure SQL Database and Azure Synapse Analytics
    Enable server and database auditing through ARM templates
    Azure SQL Server Auditing: Setting Log Analytics Destination

    Best Regards,
    Amelia


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


0 additional answers

Sort by: Most helpful