Re: SQL Login audit log

Kai,

In event viewer, there are 3 logs SYSTEM, Error (I think) and Application
Log. It should be in Application Log. OTherwise, in Enterprise Manager
expand MANAGMENT and look down to find "Current Logs" or "Logs" (you should
have the last 6 logs) top file should be the most current log. Look in that
one. This file is also in c:\program files\microsoft sql server\logs\
directory.

Oscar

"kai" <kailiang@xxxxxxxxxxxxx> wrote in message
news:R4hDe.14071$aY6.12092@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Oscar,
> Thanks for responding. I selected all, then I relogin, in the event log
> viewer, I cannot find new login. Where should I read the log?
>
> Thanks
>
> kai
> "Oscar Santiesteban Jr." <oscarsantiesteban@xxxxxxxxxxxxxxxx> wrote in
> message news:JWgDe.14190$5N3.7915@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> > Are you trying to log all SUCESSFULL logons and FAILED logons?
> > You can right-click the server in ENTERPRISE MANAGER and check the
options
> > for each.
> >
> >
> > "kai" <kailiang@xxxxxxxxxxxxx> wrote in message
> > news:crgDe.1579$6f.1305@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> >> Hi, All
> >> I use SQL Server 2000 and Win 2003 Server. I try to create a SQL
Server
> >> Login audit log using Profiler, but cannot find the tools. I looked at
> >> the
> >> Windows Event Viewer, it only logs Windows authentications users for
SQL
> >> Server not SQL Server users (Mixed mode users).
> >>
> >> Please help on creating SQL Server Login log (username,password and
> >> time).
> >>
> >> Thanks
> >>
> >> Kai
> >>
> >>
> >
> >
>
>


.

Relevant Pages

  • Re: Enterprise Manager displays nvarchar as
    ... Is Enterprise Manager running on the server or are you running remotely? ... it possible that the workstation has the original client tools ... SQL Server 2005, and is the column NVARCHARor NVARCHAR? ...
    (microsoft.public.sqlserver.tools)
  • SQL Server does not exist or access denied -Personal/Developer Edi
    ... should a database running SQL Server 2000 Developer's Edition ... access Server A, and my code executing on Computer B can access Server A. ... Enterprise Manager "New SQL Server Registration" Command (Right click Sql ...
    (microsoft.public.sqlserver.connect)
  • Re: Working with a hosted MS SQL Server database
    ... My ISP allows me to register my own database in Enterprise manager. ... Server -- especially the ones running on web servers. ... I want to be able to work with or manage an SQL Server 2000 database ...
    (microsoft.public.sqlserver.setup)
  • Re: upsizing from Access 2002 to SQL Server 2000
    ... adding another database. ... SQL Server 2000 enterprise edition (enterprise manager, ...
    (microsoft.public.sqlserver.server)
  • Re: Audit policy question with SQL 2000
    ... You can turn off the polling in Enterprise Manager by going ... the checkbox for Poll Server to find out state of server and ... >On our SQL 2000 Servers, we set the audit police in Local ... >event viewer does not register any more failed logons. ...
    (microsoft.public.sqlserver.security)