Notify user about a failed login attempt

Question

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.

Answer 1

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

Answer 2

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 [e-mail].