Re: 18454 Log message

From: Lan Lewis-Bevan [MS] (lanlb@online.microsoft.com)
Date: 11/12/02 

From: lanlb@online.microsoft.com (Lan Lewis-Bevan [MS])
Date: Tue, 12 Nov 2002 17:43:40 GMT

You may check if your server-in-question is setup for auditing. If you
don't want these msg showing up in SQL error log, you need to change the
audit option to NONE.

--Expand a server group.
--Right-click the server, and then click Properties.
--Under Audit level, select the level at which user accesses to Microsoft®
SQL Server™ are recorded in the SQL Server error log:
None, causes no auditing to be performed.
Success, causes only successful login attempts to be audited.
Failure, causes only failed login attempts to be audited.
All, causes successful and failed login attempts to be audited.

Regards,

Lan Lewis-Bevan
SQL Server Support

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

Relevant Pages

  • Re: Service account, again.....
    ... >I had decided to make the server a secure one, ... is the SQL Server ... >> where the SQL Data resides. ... >> Auditing for Object Access. ...
    (microsoft.public.sqlserver.security)
  • Re: Audit Log in Yukon
    ... Do you mean the Audit Level server setting that writes entries to the SQL ... Error Log? ...
    (microsoft.public.sqlserver.tools)
  • Re: Backup not working HELP!
    ... see the error log located in the backup directory. ... the SQL Server error log for more details. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: SQL 2000 Error: 17803, Severity: 20, State: 14
    ... OK your running 2000 SP3 but what edition? ... Server or ADV Server? ... How is the memory configured on SQL Server? ... same messages in the error log. ...
    (microsoft.public.sqlserver.server)
  • SQL Error Log is not logging events properly
    ... I have a server where the sql error log is constantly missing events. ... Usually you see when processes were killed, backups, server reboots, etc. ...
    (microsoft.public.sqlserver.security)