SQL Audit in Always On Availability Group

• PJ_SQL

  SSCertifiable

  Points: 6703

  More actions

  May 14, 2022 at 12:46 am

  #4032692

  Hello!

  I have setup SQL Audit in Always on Availability group (2 node) for ddl and dml to write to Event viewer. I have configured on both nodes using the same GUID. It writes to Event viewer in the Primary node (1) or when I fail primary and  and make secondary primary, it works.

  But, when I do select on secondary node using SSMS, it is not writing to the event viewer.

  Thanks in advance.

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  May 15, 2022 at 1:10 am

  #4033109

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• May 17, 2022 at 12:28 pm

  This was removed by the editor as SPAM