I'm having trouble with the SQL Server Log File Viewer on one of my servers (SQL 2005 Active/Passive cluster) not being able to read the Windows NT Event Log on the server. I'm getting an "Access Denied" error. Consequently I have to RDP to actual machine to read the Event Log [hassle].
What account does the Log File Viewer run under? Apparently it needs more rights.
Any other recommendations?
asked Oct 12, 2012 at 04:40 PM in Default
There are several methods mentioned on this blog - http://thelonedba.wordpress.com/2012/09/12/querying-sql-server-event-logs-to-search-for-dbcc-checkdb-output/ from @thomasrushton. You simply need to adjust the methods to search for what you want rather than the DBCC output that the blog is focussing on
My 2 pence says use Log Parser as you can very easily use it to get the log content from a large number of servers with very little alteration.