Auditing SQL Server activity to Security Logs

• sql2k8

  Hall of Fame

  Points: 3455

  More actions

  May 24, 2012 at 9:43 pm

  #256589

  Hi,

  I am planning to install SQL Server auditing. I want to store my log info to the security Log.

  when i setup the server audit. i had mentioned the path to a security log . I had created the database specification also.

  I had enabled both the instance audit and database audit. but when i do the DML activity. i was not able to capture the events to the security log. i had setup my audit events to capture dml events in the database . I had choosen the user as public. that should allow all of the users.Nothing is recorded to the security Log.

  I am using SQL Server 2008 r2 ent edition 64 bit RTM on server 2008 r2 64 bit sp1.

  when i use to log the audit to file. it records everthing . I can see it in Logs. but when i go to the file i can't see records inside.

  My main requirement is to store the events to a security log file . If the DML activity is recorded to the security logs then i can go there and watch the information.

  Can you please help me.

  Thank You,

• Orlando Colamatteo

  SSC Guru

  Points: 182276

  More actions

  May 25, 2012 at 9:39 am

  #1493251

  Please read the section titled "Writing to the Windows Security Log"

  Microsoft White Paper > Auditing in SQL Server 2008

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato