Home Forums Article Discussions Article Discussions by Author Discuss content posted by Geoff Albin How to centralize your SQL Server Event Logs. RE: How to centralize your SQL Server Event Logs.

  • May 25, 2012 at 9:26 am

    #1493238

    bev.bellisio (5/25/2012)

    I was successful setting this up on the server I wanted to use as Central server. However, when I tried to change one of my other servers' Agent properties to forward events to this server, it doesn't work. I get messages on the remote server's Event log - Unable to open the eventlog on forwarding server 'xxxxx' (reason: Access is denied). (Central server name has been masked).

    What permissions do I need to give on the Central server to allow the other servers to do this forwarding?

    Thanks!

    Bev Bellisio

    make sure that you have enabled the Distributed Transacation Coordinator on the 'sending' server.

    Under Security Settings you have to Allow Network DTC Access