|
|
Posted by Erland Sommarskog on 07/10/07 11:40
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/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|