Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««34567»»»

How to centralize your SQL Server Event Logs. Expand / Collapse
Author
Message
Posted Tuesday, May 15, 2012 3:24 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 13, 2013 5:24 AM
Points: 6, Visits: 74
great article....geoff i want IIS log events in this database...how can i do that???

thanks in anticipation
Post #1300634
Posted Tuesday, May 15, 2012 4:04 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, April 17, 2014 11:04 AM
Points: 510, Visits: 1,684
With IIS 7.0' , it's super easy because you can choose a data sources to do this. It's a setting you have to install, but it's very straight forward.
With IIS 6.0 or lower, it's another article.
Post #1300661
Posted Wednesday, May 16, 2012 1:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 13, 2013 5:24 AM
Points: 6, Visits: 74
thank you for the prompt response...we have IIS 7.5....can you point me in the right direction what steps should i take to get IIS logs into our DBA database???

thanks in anticipation
Post #1300834
Posted Thursday, May 17, 2012 7:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 13, 2013 5:24 AM
Points: 6, Visits: 74
help..!!!!
Post #1301786
Posted Thursday, May 17, 2012 8:04 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 03, 2014 12:46 PM
Points: 1,413, Visits: 4,531
will logparser work?

https://plus.google.com/100125998302068852885/posts?hl=en
http://twitter.com/alent1234
x-box live gamertag: i am null
[url=http://live.xbox.com/en-US/MyXbox/Profile[/url]
Post #1301789
Posted Thursday, May 17, 2012 8:11 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, April 17, 2014 11:04 AM
Points: 510, Visits: 1,684
perfectillusion29 (5/17/2012)
help..!!!!


http://blogs.iis.net/rakkimk/archive/2008/04/16/how-to-configure-iis-7-0-for-odbc-logging.aspx
Post #1301793
Posted Thursday, May 17, 2012 8:49 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 13, 2013 5:24 AM
Points: 6, Visits: 74
where can i find Query analyzer in sql server 2008 R2 ???
Post #1301828
Posted Thursday, May 17, 2012 8:54 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 03, 2014 12:46 PM
Points: 1,413, Visits: 4,531
its part of SSMS

https://plus.google.com/100125998302068852885/posts?hl=en
http://twitter.com/alent1234
x-box live gamertag: i am null
[url=http://live.xbox.com/en-US/MyXbox/Profile[/url]
Post #1301834
Posted Friday, May 18, 2012 7:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 13, 2013 5:24 AM
Points: 6, Visits: 74
thanks for the reply Geoff....actually i need something similar to what you did with application log i.e without using any tool(i.e log parser) and automate the task in similar fashion....any suggestion please????
Post #1302527
Posted Friday, May 25, 2012 9:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 15, 2013 11:58 AM
Points: 3, Visits: 59
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
Post #1306647
« Prev Topic | Next Topic »

Add to briefcase «««34567»»»

Permissions Expand / Collapse