Audit Login Failed Event

I know my SQL server is detecting a login failure, but how do I know who log
in incorrectly? Is there a way to record the IP Address or PC name. I need
to find out if someone just typed in a bad password or if someone Is trying
to hack my server.
thank you
JohnAudit Login option is limited with info on the structure of the Windows
Event Log. You can get more info, including comuter name, with Profiler.
Check the Profiler in Books OnLine if this is what you need.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Jwtimoney" <anonymous@.discussions.microsoft.com> wrote in message
news:418A7655-A12B-4246-8BFD-491F6F087615@.microsoft.com...
> I know my SQL server is detecting a login failure, but how do I know who
login incorrectly? Is there a way to record the IP Address or PC name. I
need to find out if someone just typed in a bad password or if someone Is
trying to hack my server.
> thank you
> John|||As Dejan says, Audit Login failuers in SQLProfiler.