Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

i want to be notified when someone tries to login to my sql server (2008); whether it succeeded or not. I found the 'alert' section under the 'sql server agent', but didn't find anything like it there.


share|improve this question
Do you want to be notified immediately or just be able to browse through the login events? – Mike Thien Mar 18 '10 at 19:00
immediately, browsig i will probably forget :) – Michel Mar 18 '10 at 21:47
up vote 2 down vote accepted

is logging it to the windows eventlog and ERRORLOG good enough? if so. Using SSMS:

  1. Right-click the database server in
    object explorer and go to properties
  2. Click on the security page
  3. Select Both failed and successful logins on the login auditing option
share|improve this answer
that was nice, the eventlog gives me the opportunity to send email when some events occur, so this does the trick – Michel Apr 10 '10 at 20:32

Not sure that feature is available built in but you can set up some scripts to do it. Try here for an example.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.