July 17, 2015 at 7:17 am
Hi, I've built 4 new SQL2012 Ent SP2 instances using our standard build docs\scripts all of which include an alert to pick up Sev 14 bad login messages.
However when I force a bad login to test these, they work on 2 servers but not the other 2.
The ones that fail write the Sev 14 msg to the SQL Error log and Windows Eventvwr fine, but there is no entry in the sysalerts table!?.
The alert is enabled and the windows event log service is running. I've noticed that none of the other alerts I've set up write to the sysalerts table though?
NB. Please note this isn't to do with mailing out, i'm not concerned about that yet, just the fact its not writing to the sysalerts table in the first place.
Thank-you
July 20, 2015 at 4:58 am
Don't worry, I've fixed it.
I'd restored MSDB over from a named instance. In sysalerts I had to change the event_source column from the named instance name with $ in it to the standard ie MSSQLSERVER
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply