February 9, 2016 at 12:55 pm
Hi,
How do I trace alerts coming from unknown AD account from SQL Server ?
Thanks,
PSB
February 10, 2016 at 4:43 am
Alerts? I'm not sure what you mean there.
Do you mean attempts at connections or failures at connections?
If so, the best tool you have for that in SQL Server 2014 is Extended Events. I'm not sure exactly what you're looking for from the question, but I'd start with the audit login event.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 10, 2016 at 5:24 am
Alerts :When an SSIS package that is executed as SQL Job fail , users are receiving an alert from test@xyz.com
How can I investigate that ? When I look at Database Mail configured that email doesn't even exist.
February 10, 2016 at 6:52 am
PSB (2/10/2016)
Alerts :When an SSIS package that is executed as SQL Job fail , users are receiving an alert from test@xyz.comHow can I investigate that ? When I look at Database Mail configured that email doesn't even exist.
Ah, well, what process is calling the SSIS package? If it's SQL Agent, look there and see how it's configured. It doesn't have to be a user on the server.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 10, 2016 at 6:59 am
Could be a "send mail task" within the SSIS package. Check for a SMTP connection which will have that email address specified in the "from" box.
February 10, 2016 at 8:37 am
Thanks!. That was it .
February 10, 2016 at 8:57 am
Good stuff, glad I could help
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply