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

xp_sendmail: failed with mail error 0x80040403

P: n/a
I'm trying to send an email using master..xp_sendmail with parms and
the default Outlook profile. I can successfully test the profile on my
own computer and on the server.

I'm running using Windows authentication and have given myself full
admin rights in MSSQL.

Which account is mssql trying to send the email from? Is it the
servers or my local clients?

The mailbox does not appear to be full and it's possible to send &
receive emails on the server and on my own machine.

What could be a possible cause or the next thing I can check?

Thanks!

Jul 10 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Stephen2 (St*****@mailinator.com) writes:
I'm trying to send an email using master..xp_sendmail with parms and
the default Outlook profile. I can successfully test the profile on my
own computer and on the server.

I'm running using Windows authentication and have given myself full
admin rights in MSSQL.

Which account is mssql trying to send the email from? Is it the
servers or my local clients?

The mailbox does not appear to be full and it's possible to send &
receive emails on the server and on my own machine.

What could be a possible cause or the next thing I can check?
If there is one thing I try to stay away from it's the combination of
mail and SQL Server. But if you need to struggle with this, consider
using xp_smtpmail instead of using xp_sendmail to save some hassle.
Check out http://www.sqldev.net/xp/xpsmtp.htm.

This is for SQL 2000. If you are SQL 2005, you should use the new stuff,
and definitely stay away from xp_sendmail.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jul 10 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.