up vote 2 down vote favorite
share [g+] share [fb]

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.

Michel

link|improve this question
71% accept rate
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
feedback

2 Answers

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
link|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
feedback
up vote 1 down vote

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

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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