Log audit events only to SQL Server Error Log?

From: Donald Welker (Donald.WelkerN0$SPAM_at_N0$SPAM.navy.mil)
Date: 12/10/04 

Date: Fri, 10 Dec 2004 12:27:03 -0800

I have an instance of SQL Server 2000 that is using only NT domain security.
It is configured to audit success and failure. [It never records a login
failure in the SQL server or application event log, I assume this is because
the login fails at Windows and never reaches SQL Server.]

Enterprise Manager help says "Log records for these events appear in the
Microsoft Windows application log, the SQL Server error log, or both,
depending on how you configure logging for the instance of SQL Server. " I
would like for these events to be logged only to the MSSQL Error Log and not
to the NT Event log. Is it actually possible to do this? How?

Relevant Pages

  • Re: catalog is empty after populating
    ... SQL Server is installed as the "Microsoft Search" service cannot write it's ... Tools -> Event Viewer and review the Application event log. ... >is only 1 MB and the catalog doesn't contain any items. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: How Do I Prevent SQL 2000 From Posting This Message To The Event Viewer - Application Log
    ... situation (event log overload from transaction replication on 40+ DBs). ... Go to the SQL Server Properties via Enterprise Manager (i.e. right ... Erland Sommarskog wrote: ... TRACEOFF turns off the trace flag! ...
    (comp.databases.ms-sqlserver)
  • Full Text Indexing Error
    ... I see a lot of these in my Event log on the SQL Server for my Windows ... These documents will not be passed to MSSearch for indexing, ... therefore this failure will not be reflected in the end of crawl summary ...
    (microsoft.public.sqlserver.fulltext)
  • Re: 18456 Login failed for user NT AUTHORITYSYSTEM
    ... Associated with this is event id 17055 from MSSQLSERVER w/description 18456: Login failed for user NT ... These messages occur in bursts of of over 100 messages every 5 minutes and just flood the application event log w/entries I think what's going on is the Alert Engine is a service running under local system and is unable to connect to SQL server. ...
    (microsoft.public.sqlserver.server)
  • Re: Cannot Connect to Configuration Database
    ... <Event Log> ... Source: Windows SharePoint Services ... the database connection information and make sure that the database server ... >> The install is in server farm mode and the SQL server is on another box. ...
    (microsoft.public.sharepoint.windowsservices)