|
|
Posted by Erland Sommarskog on 07/21/05 00:51
kai (kailiang@earthlink.net) writes:
> Thanks, it is in the "Current Log", it contains the user. In Application
> log, user shows "N/A"
Strange. I enabled login audit on my server, and this is what I found in
the Event Viewer for an SQL login:
18454 :
Login succeeded for user 'sommar'. Connection: Non-Trusted.
I'm running Windows XP, but I don't really see that would make a difference.
What I found, though, was that I had to restart the server for the setting
to have effect.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Navigation:
[Reply to this message]
|