RE: Audit log not logging

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Marc M (M_at_discussions.microsoft.com)
Date: 09/29/04 

Date: Wed, 29 Sep 2004 10:45:05 -0700

Thank you for the article. That is what I was trying to audit. I had the
auditing working before the database was moved, but now I only get the error
message in the audit log. I didn't know about the SQL Profiler before.
Thanks for pointing that out.

"Peter The Spate" wrote:

> As there is two types of auditing, have a look at the
> following article
> http://msdn.microsoft.com/library/default.asp?
> url=/library/en-us/adminsql/ad_security_2ard.asp, if its
> C2 auditing then it needs to be used in the same line as
> starting your SQL Server service.
>
> Peter
> "Denial ain't just a river in Egypt."
> Mark Twain
>
>
> >-----Original Message-----
> >Thank you for your time.
> >I have a database that i need to have auditing on. The
> database was moved
> >to a larger server. I had auditing on before the move,
> but now in my SQL
> >Sercer audit log I only have the error message 15457
> Severity: 0, State: 1.
> >I need auditing on for this database, and have not been
> able to find
> >anything online that explaines what might have caused the
> logging to stop or
> >how to fix this issue. The users can still login, but
> SQL Server isn't
> >auditing it anymore.
> >Thank you again for your time.
> >.
> >
>

Relevant Pages

  • Re: Auditing
    ... I would like to audit some tables in my database and after reading the "Informix Trusted Facility Guide" I understand that I can't choose the tables I want to audit. ... The only way I have founded to do this is auditing the access to all the tables. ... But I regularly have conversations with customers that "need" auditing and after some discussion we come to the conclusion that either they don't really need auditing or that the auditing facility cannot answer their needs. ...
    (comp.databases.informix)
  • Re: Oracle Auditing
    ... error appears to be coming from your RMAN repository. ... This is the database to be backed up, ... Nothing to do with turning auditing on or off either. ... the directory where all the audit files are appearing is not the ...
    (comp.databases.oracle.server)
  • RE: Auditing
    ... I would like to audit some tables in my database and after reading the ... auditing the access to all the tables. ... I use the auditing facility in every instance I control. ...
    (comp.databases.informix)
  • Re: Security Reporting
    ... The ultimate SQL Server 2000 security guides. ... To enable auditing of failed connections with Enterprise Manager in SQL ... On the Security tab, under Audit Level, click Failure. ...
    (microsoft.public.sqlserver.security)
  • Re: Auditing in SQL Server 2005 - Need Help
    ... Server 2000/VB6 to SQL Server 2005/VB.Net. ... meaningful audit information to the user. ... Generate audit records for all defined events, ... system resource or when auditing has been ...
    (microsoft.public.sqlserver.security)