March 22, 2011 at 12:21 pm
We have a configured , long time running DB email system. We get alerts on the SSIS scheduled jobs that we run every evening.
The alerts would be like , Jobs ran, or failed , files created at so & so destination etc.
All of a sudden since 2 days we are not getting any emails. When i run the following querry
USE msdb ;
GO
SELECT items.subject,
items.last_mod_date,
l.description FROM dbo.sysmail_faileditems as items
JOIN dbo.sysmail_event_log AS l
ON items.mailitem_id = l.mailitem_id
ORDER BY last_mod_date DESC
i get the following message in the description filed.
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2011-03-21T23:03:34). Exception Message: Could not connect to mail server. (No connection could be made because the target machine actively refused it 10.104.1.13:25). )
Can someone please tell me what is happening. Thank You
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]
March 22, 2011 at 1:06 pm
Your smtp mail server is refusing the account you specified in the dbmail setup. You may want to check that the account has permissions or that you are using the correct account / mailbox.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply