467,150 Members | 1,213 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,150 developers. It's quick & easy.

XP_SENDMAIL problem after windows trust with exchange server established

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
  • viewed: 2887
Share:
2 Replies

"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
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.

Similar topics

reply views Thread by Jeff Cochran | last post: by
7 posts views Thread by Pavils Jurjans | last post: by
7 posts views Thread by placid | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.