Auditing on a SQL Listener

  • Kris-155042

    Hall of Fame

    Points: 3267

    Hi,

    Is it possible to audit on a listener. For example I have a SQL 2017 Enterprise server that has 5 instances of SQL all with Always on Availability. One of the instances has 3 availability groups AG1 has all but 2 of the databases AG2 has the other two. I can connect to the 3rd AG and see all the databases in one view.

    Auditing is setup at a server level and the logs can be viewed at that level, but when I am connected to AG3 I can see all the databases but the audit log is empty.

    My question is to you have to be connected via the instance name only to view the audit logs or should I be able to connect to the listener and see them there as well.

    Hope this makes sense.

    Thanks


    Thanks,

    Kris

  • Site Owners

    SSC Guru

    Points: 80379

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

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

  • John Mitchell-245523

    SSC Guru

    Points: 148519

    As I understand it, auditing is set up at the instance level, not AG level.  So if you can't see any events in the audit log for AG3, I think that must mean that AG3 is running on an instance that hasn't captured any events.

    John

  • Kris-155042

    Hall of Fame

    Points: 3267

    Thanks John, I thought as much but just couldn't find anything to confirm it.


    Thanks,

    Kris

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply