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 :-)