SQL Server Performance

xp_sendmail with attachments

Discussion in 'General DBA Questions' started by avmreddy17, Jan 27, 2003.

  1. avmreddy17 New Member

    I get this ERROR when I try to use SQL Mail with an attachment
    Are there any known problems with sending mail with the attachements ( Here I am trying to attach an Excel Spread sheet)

    Server: Msg 18025, Level 16, State 1, Line 0
    xp_sendmail: failed with mail error 0x80040111


    Thanks for any help on this
    Venu
  2. tkelley New Member

    That's the MAPI error number for MAPI_E_LOGON_FAILED. Being that you are finding
    problems with xp_sendmail, you should check the mail profile used by SQL Mail which
    would be the SQL Server service account. xp_sendmail uses the SQL Server service
    account. SQL Agent mail properties and the SQL Agent service account are used when
    sending notifications from jobs, alerts, etc. You can find more info in the following
    Knowledge Base article: INF: How to Configure SQL Mail (Q263556)
    http://support.microsoft.com/defaul...b;en-us;Q263556

    ( - credit a lady named Sue for this answer)




    ----------
    T Kelley
    MS, MCDBA, OCA, CIW

  3. amritsinghpal New Member

    I have been doing this. I tried to send a simple sql mail and it works perfectly alright, but when I try to send in an attachment it fails with the abovesaid error. The MAPI profile which I have created is with the same account which was used to start the sql server. when I test it while configuring sql mail, the report comes fine.Please advice.
    Thanks in advance

Share This Page