Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2002
    Posts
    14

    Unhappy Unanswered: xp_sendmail: failed with mail error 0x80070005 [SQLSTATE 42000]

    Error:
    Msg 18025, Sev 16: xp_sendmail: failed with mail error 0x80070005 [SQLSTATE 42000]

    Using Windows 2000, Microsoft Exchange Server 2000 and SQL Server 2000.


    I have a job where I make a few queries then I send a late notice through email when required...

    The SQL Mail is running.

    EXEC [master].[dbo].xp_sendmail @recipients 'someaddress@domain.com',
    @message = 'Employee #xxxx .......',
    @subject = 'Late Notice'

    It doesn't work. I this error:
    --+++++++++++++++++++++++++++++++++++++++++++++
    Msg 18025, Sev 16: xp_sendmail: failed with mail error 0x80070005 [SQLSTATE 42000]
    --+++++++++++++++++++++++++++++++++++++++++++++

    The job works well when this part is commented out.



    Any ideas?

    gdo

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Take a look at the following article:

    ms article

  3. #3
    Join Date
    Jul 2002
    Posts
    14

    Unhappy

    Tried that already and it did not fix the problem...

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    Does it happen every time ? Execute xp_sendmail, twice - back to back and see if it still happens. We had this occur on our box - but the error normally only appeared once and then subsequent calls to xp_sendmail worked fine. Let me know.

  5. #5
    Join Date
    Jul 2002
    Posts
    14

    Talking Grrreat!

    I got sick or trying so I was working on something else...

    Then I just tried like you suggested twice back to back and it worked!

    I tried it again after but just once and it worked just fine.

    Thanks!

    Anyway, what is that problem caused by???

    gdo

  6. #6
    Join Date
    Feb 2002
    Posts
    2,232
    The gelatinous cube that is microsoft will not reveal the answer - it is like poking the sleeping dragon to get his lazy butt to wake up. Butt seriously, I think it is just an initialization problem (because it will probably rear its ugly head again, not immediately though) - it could be just that something gets corrupted the first time the object is invoked
    or a timing issue where the credentials beat the instantiation of the object. Anyway, make sure that where you use the xp_sendmail to have an error trap - or just have xp_sendmail run periodically that sends something back to you to make sure it doesn't nod off again.

    Good luck.

Posting Permissions

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