By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,693 Members | 1,936 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,693 IT Pros & Developers. It's quick & easy.

XP_SENDMAIL problem after windows trust with exchange server established

P: n/a
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@<otherdomain> rather
than admin@<normaldomain> and therefore thinks that agent account is
different than the mail account.

Please help if you can.

Thanks.

Jul 23 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a

"Eric Timely" <en**@consultant.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
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@<otherdomain> rather
than admin@<normaldomain> and therefore thinks that agent account is
different than the mail account.

That's probably it.

One tip I've found helpful is to make sure your Outlook agent (or whatever
MAPI email aganit you're using) has ALL its mailboxes (sent, deleted,
in,etc)EMPTY

BTW, if you're simply SENDING email, the most bulletproof thing I've found
is to setup the IIS SMTP mail server on the same physical box as SQL Server,
lock it down so only that box can send email through it and point your MAPI
client to the SMTP server for sending email.

Since I've done this, I've eliminated the problem of XP_sendmail locking up
when it tries to send mail and the MAPI client has hung because of a timeout
waiting for the server it's sending too.

Please help if you can.

Thanks.

Jul 23 '05 #2

P: n/a
Thanks.
Eventually I deleted the account on the remote domain. Recreated it and
added permissions (mailbox and security "send as") and everything
worked.

We were trying to stay away from an SMTP/POP account for stability and
security reasons.

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.