Wednesday, March 7, 2012

HELP! - cant send mail

xp_sendmail has died on our SQL Server, I get error "xp_sendmail:
failed with mail error 0x80004005" if I try using it.

I believe that the reason that this has happened is because the SQL
Server service account is unable to send mail, as follows:

If I log on to Outlook Web Access as the SQL Server service account
(SVC_SqlServer) I am able to receive mail. However, any mail sent from
this account simply dissapears.

It appears in the Sent items folder (in OWA for the SVC_SqlServer
account) but the recipient (me, in this case) never receives it!

Does anyone know why this account is unable to send mail?

Help!

eddiec :-)chalk@.netspace.net.au wrote in message news:<79744f05.0402112113.3a3a7640@.posting.google.com>...
> xp_sendmail has died on our SQL Server, I get error "xp_sendmail:
> failed with mail error 0x80004005" if I try using it.
> I believe that the reason that this has happened is because the SQL
> Server service account is unable to send mail, as follows:
> If I log on to Outlook Web Access as the SQL Server service account
> (SVC_SqlServer) I am able to receive mail. However, any mail sent from
> this account simply dissapears.
> It appears in the Sent items folder (in OWA for the SVC_SqlServer
> account) but the recipient (me, in this case) never receives it!
> Does anyone know why this account is unable to send mail?
> Help!
> eddiec :-)

This KB article might be helpful:

http://support.microsoft.com/defaul...B;EN-US;q293422

It's not entirely clear from your post if xp_sendmail used to work and
now does not work; if SQL Mail has never worked, then you might also
want to look at this article:

http://support.microsoft.com/defaul...6&Product=sql2k

Simon

No comments:

Post a Comment