May 4, 2005 at 9:13 am
Please advise on how to resolve the below error - this happens sometimes not all the time -
Executed as user: NT1\Administrator. xp_sendmail: failed with mail error 0x80040115 [SQLSTATE 42000] (Error 18025). The step failed.
Many thanks,
May 4, 2005 at 10:17 am
That's a network error. This could be either the exchange server is down, or the SQL Server is having network problems.
A full list of the MAPI error codes can be found at http://support.microsoft.com/default.aspx?scid=kb;en-us;Q238119
May 5, 2005 at 2:06 am
Here's a good one that most people do not know about.
We recently moved into a new data centre with an outsourcing provider who implemented a firewall between the data tier (where all the SQL Servers are) and the application tier (where the Exchange server is).
The upshot is that although the appropriate holes are available in the firewall, if an sql server does not send an email for 1 hour, then the firewall closes the connection.
To get round this we have had to set up a job that does an xp_Stopmail and an xp_Startmail.
Hope this helps
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply