Posted by Oscar Santiesteban Jr. on 07/20/05 05:12

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@earthlink.net> wrote in message
news:R4hDe.14071$aY6.12092@newsread1.news.atl.earthlink.net...
> 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@worldnet.att.net> wrote in
> message news:JWgDe.14190$5N3.7915@bgtnsc05-news.ops.worldnet.att.net...
> > 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@earthlink.net> wrote in message
> > news:crgDe.1579$6f.1305@newsread3.news.atl.earthlink.net...
> >> 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
> >>
> >>
> >
> >
>
>

[Back to original message]