Post reply

xp_sendmail Problem

  • January 13, 2006 at 2:00 pm

    #115961

    Hello All,

    When I run the following command from QA:

    EXEC master..xp_sendmail @recipients = 'username@domain.com', @message = 'testing email.', @subject = 'testing email'

    I receive the following error:

    Server: Msg 18025, Level 16, State 1, Line 0

    xp_sendmail: failed with mail error 0x80070005

    I can send mail via EM Operator test, I can successfully stop and start the SQL Mail Profile and I can send mail via Outlook 2000 using that same mail account. My services are both started using the same domain level mail account. I'm just receiving the error whenever I use the xp_sendmail SP.

    Does anybody have any ideas??

    I've looked up the following MS KB related support:

    http://support.microsoft.com/kb/293422/EN-US/

    http://support.microsoft.com/default.aspx/kb/820220

    No real luck.

    Thanks in advance for your help!

    Ronnie 

  • January 16, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • January 16, 2006 at 8:58 am

    #614932

    Are you in the sysadmin role? 

    If so, it may be that when you are running the query in your QA, it is impersonating your account (not the SQL Service account) and your account may not have the "Send As' permissions as described in kb293422.

    Hope this helps



    Mark

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply