Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

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

2 Answers 2

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

 
discard

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.