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

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]