SQL Server Performance Forum – Threads Archive
xp_send mail error in sqlserver 2000/2005we are having sqlserver 2000 and sqlserver 2005 on our windows 2000 servers.(prob 6 servers)
and all of those are using the exchange server 2003.
suddenly in the morning all the master_dbo.xp_sendmail are failing with error
xp_sendmail:failed with mail error 0x80004005 ,
xp_sendmail:failed with mail error 0x80040111
is there any place where i can look and know what’s happening orr is there any solution for this…
Look at this: http://support.microsoft.com/default.aspx/kb/293422 Satya
but the article you referred is for exchange server 2000, but we are using the microsoft exchange server 2003;
Sataya provided the KBA for the 0x80004005 error code. Here is the KBA for the 0x80040111 http://support.microsoft.com/kb/327552 "This error code means "MAPI_E_LOGON_FAILED."
Do have upto date service packs on SQL & Exchange services?
KBAhttp://support.microsoft.com/kb/153159/EN-US/ and forum posthttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9278 fyi in relation to the problem. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Is exchange rebooted? or were there any network issues…? You may experience this type of issue when sql can’t establish the connection when it tried to send an email… Try the following…
1. Stop and restart sql mail and then test…if not working then…
2. Restart the sql services.. If you are not getting sql agent alerts then try to restart sql agent to resolve this…
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.