After a trust with exchange server established the xp_SendMail
gives the following error:
xp_sendmail: failed with mail error 0x80070005
Prior to the trust everything worked fine.
I have tried the following:
1)Checking SQL and SQLAgents accounts all match up with default mail
profile.
2)Confirmed I could send from outlook logged in under the account.
3)xp_stopmail and xp_startmail
4)restarted the SQL Agent
5)Confirmed outlook settings as defined in:
kb153159 -
http://www.sqlnewsgroups.net/link.as.../153159/EN-US/
I also tried a pop3 account just to test, but no luck.
I think what is happening is now that the trust is established when SQL
makes a mail contection it thinks it is user admin@<otherdom ain> rather
than admin@<normaldo main> and therefore thinks that agent account is
different than the mail account.
Please help if you can.
Thanks.