GFI
English Deutsch Français Italiano Nederlands Español
Forums  Register  Login  My Profile  Inbox  Address Book  My Subscription  My Forums 

Member List  Search  FAQ  Ticket List  Log Out

 

Configure SQL Server Auditing

  		Logged in as: Guest
Users viewing this topic: none
  Printable Version
All Forums >> [Network Security] >> GFI EventsManager >> Configure SQL Server Auditing Page: [1]
Login
Message << Older Topic   Newer Topic >>
Configure SQL Server Auditing - 16.Jul.2008 1:14:41 PM   
quantumkyle

 

Posts: 3
Score: 0
Joined: 25.Apr.2008
Status: offline 		I've searched the forum and I still have questions.

We have EM8 setup to archive all sql audit logs, but we're not getting everything that we would expect.  We are getting log ins and log outs, but we're not getting some things like creation of new databases or queries, etc.  We need to log all of that for PCI compliance.

I read somewhere where somebody metioned setting up a trace on the SQL server.  Do I need to do this and if so how?

Thanks in advance...

< Message edited by quantumkyle -- 17.Jul.2008 9:49:49 AM >
Post #: 1
RE: Configure SQL Server Auditing - 17.Jul.2008 3:27:26 PM   
spidermouse

 

Posts: 52
Score: 0
Joined: 27.Jul.2006
Status: offline 		Yep. No profiler, no decent DB auditing.

Here is all you need to know, and probably more than you ever want to know...

http://technet.microsoft.com/en-us/library/ms187929.aspx

_____________________________

Regards,

Spidermouse

----------------------------------------------------------
Mythbusters - busting myths since 1972...

(in reply to quantumkyle)
Post #: 2
Page:   [1]
All Forums >> [Network Security] >> GFI EventsManager >> Configure SQL Server Auditing Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts


   © 2008. All rights reserved. GFI Software Home Products Download Trials Support Ordering Site Map About Us Contact us
GFI solutions: Exchange anti spam filter - exchange anti virus - isa server - network vulnerability scanner - event log management - USB security software - exchange archiving - fax server software