"Cannot open log Application on machine" from SQL Log File Viewer

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?

more ▼

asked Oct 12, 2012 at 04:40 PM in Default

avatar image

90 1 3 6

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Oct 13, 2012 at 10:56 AM

avatar image

Fatherjack ♦♦
43.7k 79 98 117

Log Parser looks uber cool, I'll check it out. Thanks for taking the time to help.

Oct 13, 2012 at 07:02 PM willspurgeon

Great that you are going to try LogParser, its a great tool to understand and use. I wrote a series of blogs on it, here's a link to the first one - http://www.simple-talk.com/blogs/2010/05/24/using-logparser-part-1/. it might be of use to you but the documentation that comes with it is really comprehensive. Start a new question here anytime you want a hand.

Oct 14, 2012 at 09:55 AM Fatherjack ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 12, 2012 at 04:40 PM

Seen: 846 times

Last Updated: Oct 14, 2012 at 09:55 AM

Copyright 2016 Redgate Software. Privacy Policy