SQL Server Performance

xp_send mail error in sqlserver 2000/2005

Discussion in 'SQL Server 2005 General DBA Questions' started by priyaram, Jun 21, 2007.

  1. priyaram New Member

    we 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...


    thanks,
  2. satya.sqldba New Member

  3. priyaram New Member

    but the article you referred is for exchange server 2000, but we are using the microsoft exchange server 2003;
  4. CG2000 New Member

  5. satya Moderator

    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
    http://www.SQL-Server-Performance.Com
    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.
  6. MohammedU New Member

    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...


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

Share This Page