Post reply

Auditing on a SQL Listener

  • December 5, 2019 at 4:07 am

    #3704621

    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

  • December 6, 2019 at 4:10 am

    #3705221

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

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

  • December 6, 2019 at 8:14 am

    #3705254

    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

  • December 6, 2019 at 8:41 am

    #3705257

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

    Thanks,

    Kris

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

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