SQL Server Performance Forum – Threads Archive

xp_sendmail: failed with mail error 0x80004005

I have recently changed SQL Logon domain user expample: from aax1 to aax2.. Now aax2 is being used for running sql and agent services. There used to be a MAPI profile on server by the name sql1 that has been removed and new profile created by the name sql2. Now I have added sql2 profile in ‘SQL Mail’. changed SQL Agent Mail session to be run using sql2 profile..recreated operator and tested.. it is sending emails. But when i am executing xp_sendmail from query analyzer [checked with ‘sa’ account/ windows authentication].. it is showing below error all the time: –
EXEC master..xp_sendmail
@recipients=’[email protected]‘,
@message = ‘test’ Error: – Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x80004005
What went wrong? any idea…
Deepak Kumar –An eye for an eye and everyone shall be blind

Try this CREATE PROCEDURE SendMail(
@From varchar(255),
@To varchar(255),
@Message varchar(8000),
@Subject varchar(255))
AS DECLARE @CDO int, @OLEResult int, @Out int –Create CDONTS.NewMail object
EXECUTE @OLEResult = sp_OACreate ‘CDONTS.NewMail’, @CDO OUT
IF @OLEResult <> 0 PRINT ‘CDONTS.NewMail’
EXECUTE @OLEResult = sp_OASetProperty @CDO, ‘BodyFormat’, 0
EXECUTE @OLEResult = sp_OASetProperty @CDO, ‘MailFormat’, 0 –Call Send method of the object
execute @OLEResult = sp_OAMethod @CDO, ‘Send’, Null, @From, @To, @Subject, @Message, 1 –0 is low 1 is normal
IF @OLEResult <> 0 PRINT ‘Send’ –Destroy CDO
EXECUTE @OLEResult = sp_OADestroy @CDO return @OLEResult
Madhivanan Failing to plan is Planning to fail

— Forgot to write that.. I have checked after restarting SQL Agent services and removed all old sent/inbox items from emails. BUT can not take 1 min downtime to restart whole Server. Ahhh.. there were a lot content to read for similar error on web, but nothing like that is matching with my problem situation. Deepak Kumar –An eye for an eye and everyone shall be blind

<blockquote id="quote">quote:<hr height="1" noshade id="quote">Originally posted by Madhivanan Try this <pre id="code">CREATE PROCEDURE SendMail( return @OLEResult </pre id="code"> Madhivanan Failing to plan is Planning to fail <hr height="1" noshade id="quote"></blockquote id="quote"> This is OK.. I can use this… But I am more intrested to know what went wrong..what did I miss.. ?? Thanks for your quick reply <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> Deepak Kumar –An eye for an eye and everyone shall be blind

See if this helps you
http://support.microsoft.com/default.aspx?scid=kb;en-us;555180
Madhivanan Failing to plan is Planning to fail

Already tried with "exec master.dbo.xp_stopmail" but No Luck !!
Deepak Kumar –An eye for an eye and everyone shall be blind

A few more:
http://support.microsoft.com/default.aspx?kbid=820220
http://support.microsoft.com/kb/293422/EN-US/

I have similar problem with one of our production servers as well.

Have you tried this after restarting database server..?? I am facing this problem on Win 2003 Ent Edition server.. Outlook 2002, SQL 2000 Ent Ed+ Sp3a.

quote:Originally posted by danan_xu I have similar problem with one of our production servers as well.

Deepak Kumar –An eye for an eye and everyone shall be blind

Champs : Any idea how to resolve it.. what is causing this problem?? Deepak Kumar –An eye for an eye and everyone shall be blind

Is there any way other then reinstalling Outlook?? Deepak Kumar –An eye for an eye and everyone shall be blind

Thanks Argyle, I have got solution.. Sorry for replying so late <img src=’/community/emoticons/emotion-5.gif’ alt=’;-)’ /> http://support.microsoft.com/kb/293422/EN-US/</a> help me to rectify it.. "danan_xu" You can also try with below steps.. 1. Open the Active Directory Users and Computers Snap-In. 2. Locate the user object directly associated with the Exchange 2000 mailbox and select it. 3. Right-click to get the properties for this account or mailbox object. 4. Click the Security tab. (If the Security tab is not showing, select Advanced Features from the View menu; this will show the Security tab.) 5. In the Security dialog box, click Advanced. 6. In the Access Control Settings for XXX dialog box, click ADD. 7. Locate, and then select the Active Directory account that the MSSQLServer service is logging in as. 8. Make sure that the Allow Onto list box is set to This object and all child objects. 9. In the Permission Entry for XXX dialog box, scroll down in the Permission pane, and under the Allow column, select Send As. 10. Press OK three (3) times to apply the change on all the open dialog boxes. Deepak Kumar –An eye for an eye and everyone shall be blind

Hi, I have seen the http://support.microsoft.com/kb/293422/EN-US/ link. According to MS this error applies to SQL Server Standard Edition. However, I am having SQL Enterprise +SP3 and I am frequently getting such errors in scheduled jobs. These jobs are using xp_sendmail to send mails. I have gone through many articles on the net but to no success. If anybody facing the same problem on Enterprise Ed. +SP3 pls. let me know Regards, Chetan Jain

It would apply to all SQL 2000 editions since the solution to the problems is outside the scope of SQL Server. It has to do with setting the correct rights in Active Directory ("Send As" rights on the Exchange 2000 mailbox object in the Active Directory)

Thanks Argyle for your quick response.[8D] But I am wondering why MS is not giving proper info. Anyways, I will try this and hope it works for me.
Regards, Chetan Jain.

Hello,
The thread is a bit old but thought to contribute that you can get the same

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

error if the Mail Store is full. I.e. when you empty it, all is good in wonderland again!
Regards,
hanslindgren

If you are trying to add an attachment to the email make sure what you are attaching actually exists. A non existent file will cause this error.

]]>