none
Notify user about a failed login attempt

    General discussion

  • Is there a way to notify user(windows user) through email that his/her login attempt has failed providing the reason code?

    Prasenjit Gupta DBA Tata Consultancy Services Ltd.

    Monday, June 11, 2018 1:57 PM

All replies

  • Yes, you can monitor the SQL Error log via procedure, this procedure would read the error log and whenever it finds a login failed entry it would send an e-mail for the windows user using database mail
    Monday, June 11, 2018 2:06 PM
  • Hi Prasenjit,

    In your scenario, you want to send an Email alert when there's someone login failed. Right?

    If so, please refer to following article, see if it helps:

    https://www.mssqltips.com/sqlservertip/2595/get-alerts-for-specific-sql-server-login-failed-events/

    Thanks,
    Xi Jin.


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, June 12, 2018 5:53 AM