Results 1 to 4 of 4

Thread: xp_sendmail

  1. #1
    Join Date
    May 2004
    Posts
    36

    Unanswered: xp_sendmail

    i'm trying to send email using sql server, but every time i try to run xp_sendmail i get this message:

    xp_sendmail: failed with mail error 0x80040111


    can anyone tell me what this error means???

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Check MSDN.

    -PatP

  3. #3
    Join Date
    Apr 2004
    Posts
    10

    Permissions

    Im not sure the exact error code but here are some check points when settings up SQL Mail.

    1. Make sure that the user SQL Server is running under has access to the mailbox you are trying to send mail via (you may need to set the logon as under control panel/admin tools/services).

    2. Make sure you have setup your MAPI client (outlook) on the SQL Server and configured the correct account in Control Panel/Mail.

    3. If your sure you have set the above up correctly re-start SQL server as you may need to apply the security permissions.

  4. #4
    Join Date
    May 2004
    Posts
    36
    thank you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •