xp_sendmail: failed with mail error 0x80004005

Ever get this error with MS SQL2000? 
xp_sendmail: failed with mail error 0x80004005
Microsoft would have you doing all sorts of shenanigans with Active Directory.

In my case, xp_sendmail would work fine from one server, but not another. They both used the same AD account, so that didn't seem too logical of a fix.

Restarting SQL Server Agent service didn't help. Simply running these 2 stored procedures fixed it: 

EXEC xp_stopmail 
EXEC xp_startmail
All I can figure is that there was a communication breakdown between my SQL server and Exchange and SQL doesn't recover very gracefully from that.
Posted by Terry Schmitt. Tagged as database
07Sep

5 Comments for xp_sendmail: failed with mail error 0x80004005

  1. Bob Coppedge says:
    Sep 10, 2008 10:45:00 AM
    Thanks for the tip. Worked like a charm.
    Reply
  2. SQL User says:
    Oct 3, 2008 4:31:00 PM
    It works...
    Reply
  3. Ben Joyce says:
    Mar 30, 2009 11:03:00 AM
    Brilliant! This has bugged me on and off for years... works perfectly. Thanks.
    Reply
  4. Grandmere says:
    May 19, 2009 9:07:00 PM
    Good job son!
    Reply
  5. Dave Bernero says:
    May 25, 2010 3:25:00 PM
    Works Great!!! Thanks!!
    Reply

Leave a Reply