Posted by kai on 07/20/05 16:55

Oscar,
Thanks, it is in the "Current Log", it contains the user. In Application
log, user shows "N/A"

Kai
"Oscar Santiesteban Jr." <oscarsantiesteban@worldnet.att.net> wrote in
message news:sqiDe.14532$5N3.10185@bgtnsc05-news.ops.worldnet.att.net...
> 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]