I'm new to SCOM 2007. Im trying to setup alerts and views for failed SQL login attempts. I've been on the internet for hours without any luck.
My test case is trying to connect to SQL server on the same machine with invalid login details.
Can someone please give me step by step instructions to accomplish this?