I would like to generate an alert in SQL Compliance Manager if someone attempts to login with a login that doesn't exist in SQL Server. Does anyone have a simple way to do that? I was originally trying to set one up under SQL Agent Alerts triggering on Message Text "Could not find a login matching" but I can't get it to fire. So I decided to try using SQL CM.
Thanks