Showing posts with label alogin. Show all posts
Showing posts with label alogin. Show all posts

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 !
>