Data Access Auditing

• Steve DiDomenico-197994

  Mr or Mrs. 500

  Points: 578

  More actions

  September 20, 2005 at 2:41 pm

  #89287

   

  Hello,

  Can someone refer me to any articles on Data Access Auditing Packages for SQL Server? Maybe comments or suggestions as to what you are using. 

  We have a single instance of SQL Server 2000 running on a Windows 2000 Server. We are a non-profit.  Including the IT Staff, we have about 15 internal Users. 

  I think I need to monitor for both authorized access and unauthorized access.

  Can I get away with monitoring the logs manually on a daily basis and not using a thrid party add-on?

  Thanks,

  Steve

• Yelena Varshal

  SSC-Dedicated

  Points: 34286

  More actions

  September 20, 2005 at 3:49 pm

  #591530

  Hi,

  For just auditing SQL Server logins you may use Profiler Server Trace,  I used it, for events:

  -- 14 Login

  -- 15 Logout

  -- 20 Login Failed

  For alerts you may use Windows Administrative Alerts or SQL Server Alerts.

  And yes, it is a very good idea to manually check logs in addition to traces and alerts.

  Yelena

  Regards,Yelena Varsha