Wednesday, March 7, 2012

Audit login failure (with generation of alerts)

Hi,
I'm looking for a method to generate a Alert (Through SQL Agent) when a
login failure is detected on my SQL servers.
I managed to audit this through profiler, but I'm looking for something
which can be handled by the SQL Agent.
Thanks,
Chris
________________________________________
______
It's still better that if it would have been worst, isn't it ?
C'est toujours mieux que si c'etait pire !Set up an alert of 18456, and have it respond by sending you an Email.
Simon Worth
"Chris V." <tophe_news@.hotmail.com> wrote in message
news:Oy7wUnjKFHA.484@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I'm looking for a method to generate a Alert (Through SQL Agent) when a
> login failure is detected on my SQL servers.
> I managed to audit this through profiler, but I'm looking for something
> which can be handled by the SQL Agent.
> Thanks,
> Chris
> --
> ________________________________________
______
> It's still better that if it would have been worst, isn't it ?
> C'est toujours mieux que si c'etait pire !
>

No comments:

Post a Comment