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!

Stephen2 (Stephen@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, esquel@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