x

"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

willspurgeon gravatar image

willspurgeon
90 1 1 3

(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

Fatherjack gravatar image

Fatherjack ♦♦
42.4k 75 78 108

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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x161

asked: Oct 12, 2012 at 04:40 PM

Seen: 682 times

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