Using Login Auditing in SQL Server

How do you know if someone is trying to hack into your server? Auditing logins gives you a way to see if attempts are being made, and it's surprisingly easy to configure. SQL security expert Brian Kelley shows you how to set it up.

Brian is a SQL Server author, columnist, and MVP focusing primarily on SQL Server security. He currently serves as database administrator / architect at AgFirst Farm Credit Bank where he can focus on his passion: SQL Server. He formerly served as a systems and security architect for AgFirst Farm Credit Bank where he worked on Active Directory, Windows security, VMware, and Citrix. In the technical...

Lars Mikkelsen on 3/11/2009

The second question had an error :/

Abi on 12/12/2009

good video

Bala on 12/14/2009

nice video...

D151BB6B9F on 9/29/2010

If logging not turned on, does it still write to the system log? Answer that in the video and it's a 5, not a 4.

Diana Dee on 9/30/2010

Great! Now show how to audit login events using an Event Notification.

Syed Hassan on 10/1/2010

Fairly simple video but very informative for beginners. Thanks!

WChaster on 10/8/2010

All the information, nice.

John O'Sullivan on 8/4/2011

a great tip

amir on 8/4/2011

nice explaination

Ramkumar Murugesan on 8/4/2011

Neat Article... Appreciate it

Mark Horninger on 8/4/2011

Was great would have been better if C2 auditing was covered as well.

Rohan on 8/4/2011

Great learn for the day!!! Thank you, Rohan

Michael on 8/5/2011

Video was incomplete

talluri on 8/5/2011

if you choose to log successful attempts then error log will increase significantly

Iryna on 8/8/2011

Thank you.

WChaster on 8/8/2011

Why do the event entries go to applications and not security

Maurice Ivory on 12/29/2011

I thought got the first quetion right!!