Re: error message not being logged to windows event log

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Alan J. McFarlane (alanjmcf_at_yahoo.com.INVALID)
Date: 03/23/04 

Date: Tue, 23 Mar 2004 16:44:50 -0000

Sue Hoegemeier <Sue_H@nomail.please> wrote:
> On Mon, 22 Mar 2004 15:46:08 -0800, "anon"
> <anonymous@discussions.microsoft.com> wrote:
>> I have done that but still it is not being logged. My log in
>> consists of me opening a new window in Query Analyzer and logging in
>> with a SQL Server login and password, not through Windows
>> authentication, though I don't think this would matter....
>>
I'm no expert in SQL/MSDE, far from it. But from what I've (remembered of
what) I've read, I thought the login audit logging only went to file
LOGS\ERRORLOG and not to the Event Log.

Anyway that's the behaviour I see here: AuditLevel=3 and I get entries in
the ERRORLOG but nothing apparent in the Event Log. I'm not using SQL
authentication so the entries are of the form:
  2004-03-19 21:39:25.81 logon Login succeeded for user 'DOM\usr'.
Connection: Trusted.
and if I try sa not using the correct password I get:
  2004-03-23 16:33:57.51 logon Login failed for user 'sa'.

I may well be wrong on the non logging to the Event Log...but check the
contents of ERRORLOG anyway to see if the logging is occuring there.

>> Is there anything I'm missing here?
>>
> Did you restart SQL Server after changing the audit logins
> setting?
>
Or maybe that has solved it already... 

-- 
Alan J. McFarlane
http://homepage.ntlworld.com/alanjmcf/
Please follow-up in the newsgroup for the benefit of all.

Relevant Pages

  • Re: Cant Stay Signed in for more than a minute
    ... So when browsing ebay I need to sign in every few minutes. ... >> I use XP and IE6, and sometimes suffer from Excess Login Syndrome. ... It seems that keeping that first window ... > gets on my ear'ole having to keep logging in all the time. ...
    (uk.people.consumers.ebay)
  • Disconnected XP Laptop and Active Directory
    ... He is fine logging in when he's at the office, ... he is disconnected from the network, it takes 2 to 3 minutes to login. ... cause (since I am getting the 1054 errors in the event log). ...
    (microsoft.public.windowsxp.network_web)
  • RE: Login restrictions in NIS environment
    ... Login restrictions in NIS environment ... need to ban root from logging in remotely except from certain IP ... but it does not allow root to login even ...
    (RedHat)
  • Re: Workstations login takes ages to proceed after installing ISA 2004
    ... Regarding the login problem - after logging in, in ISA management, run a ... query in the logging page about the last 5 minutes and see what connections ... were denied, if any, or what happened during the time that the login was ... Ori YosefiISA Server Team ...
    (microsoft.public.isa)
  • RE: Login restrictions in NIS environment
    ... to ban root from logging in remotely except from certain IP addresses. ... but it does not allow root to login even from ... > stack is called by both login and ssh access. ...
    (RedHat)