June 16, 2004 at 11:28 am
Microsoft has a know issue with xp_sendmail and MS Outlook 2003, related to MAPI profile connection error. After following all of the steps to set up SQLAgent mail and SQL Mail or xp_sendmail. The SQLAgent mail will work however the SQL Mail or xp_sendmail will fail when tring to run a stored procedure were the xp_sendmail is used. The error message that comes back is :
SQL Mail session started.
Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x80070005
The problem is related to MS Outlook 2003 and SQL Mail or xp_sendmail. Xp_sendmail will lose the MAPI profile connection when Outlook 2003 is not running. In other words, MS Outlook 2003 must always be running in order for xp_sendmail to work.
The work-a-round from Microsoft is to put MS Outlook 2003 in the startup folder, so that whenever the server is taken down for maintence or restarts, the MS Outlook 2003 will start when the system reboots.
At this time Microsoft does not have a fix.
TT
June 16, 2004 at 11:48 am
Best way around this is to use Outlook 2000.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply