Posted by kai on 07/20/05 03:41

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]