Database mail configuration

I have configured database mail using the wizard, but when I try to send a test message I receive the following error:

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 Exception Message: Cannot send mails to mail server. (Failure sending mail.)

Is there some more configuration I must do? I have enabled mail using the surface area configurator.

Thanks

I would try using xpsmtp mail and forget standard SQL mail...it is a pain in the rear. You can get it (yes it is free) here http://www.sqldev.net/xp/xpsmtp.htm

It is easy to set up and use and has teriffic documentation.

I know this is not an answer to your question but I hope this helps some.

Regards,

Brad Feaker
|||We are using SQL Server 2005 and its database mail option, not the old SQL mail that 7 and 2000 use.|||Sorry about that - I should have noticed your mention of the Surface Area Configurator. My bad! I don't have any experience setting up SQL Mail in 2005 yet. Hope you get an answer soon. No one seems to be able to answer my question either...Good luck!!!
|||

Hi Tim,

I had the same problem as yours and I solved it configuring the Relay options of my SMTP server.

HTH,

Database Mail

All,
I'm trying to test sending mail using SQL Server 2005. I have configured
database mail but I'm getting the following error:
The mail could not be sent to the recipients because of the mail server
failure. (Sending Mail using Account 10 (2007-02-13T12:38:53). Exception
Message: Could not connect to mail server. (An established connection was
aborted by the software in your host machine).
Has anyone ran into this. I have been able to setup the same thing on my
local machine and it works fine. Any suggestions would be appreciated.
JamalHi,
try sending a mail using the information entered in the GUI using the
telnet command. there should be a more specific error than the actual
posted.
http://www.activexperts.com/activemail/telnet/
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
--|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Jamal,
Any luck finding a solution? I'm getting the same error message.
Ron
"Jamal" wrote:

> All,
> I'm trying to test sending mail using SQL Server 2005. I have configured
> database mail but I'm getting the following error:
> The mail could not be sent to the recipients because of the mail server
> failure. (Sending Mail using Account 10 (2007-02-13T12:38:53). Exception
> Message: Could not connect to mail server. (An established connection was
> aborted by the software in your host machine).
> Has anyone ran into this. I have been able to setup the same thing on my
> local machine and it works fine. Any suggestions would be appreciated.
> Jamal
>
>|||Problem turned out to be that port 25 was blocked. In the VirusConsole
=> Access Protection => Prevent mass mailing worms from sending mail
Ports 25
Added these to the exception list
SQLWb.exe,MsDtsSrvr.exe,SQLAgent90.exe,DtsDebugHost.exe,DatabaseMail90.exe

Database Mail

All,
I'm trying to test sending mail using SQL Server 2005. I have configured
database mail but I'm getting the following error:
The mail could not be sent to the recipients because of the mail server
failure. (Sending Mail using Account 10 (2007-02-13T12:38:53). Exception
Message: Could not connect to mail server. (An established connection was
aborted by the software in your host machine).
Has anyone ran into this. I have been able to setup the same thing on my
local machine and it works fine. Any suggestions would be appreciated.
Jamal
Hi,
try sending a mail using the information entered in the GUI using the
telnet command. there should be a more specific error than the actual
posted.
http://www.activexperts.com/activemail/telnet/
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi Jamal,
Any luck finding a solution? I'm getting the same error message.
Ron
"Jamal" wrote:

> All,
> I'm trying to test sending mail using SQL Server 2005. I have configured
> database mail but I'm getting the following error:
> The mail could not be sent to the recipients because of the mail server
> failure. (Sending Mail using Account 10 (2007-02-13T12:38:53). Exception
> Message: Could not connect to mail server. (An established connection was
> aborted by the software in your host machine).
> Has anyone ran into this. I have been able to setup the same thing on my
> local machine and it works fine. Any suggestions would be appreciated.
> Jamal
>
>
|||Problem turned out to be that port 25 was blocked. In the VirusConsole
=> Access Protection => Prevent mass mailing worms from sending mail
Ports 25
Added these to the exception list
SQLWb.exe,MsDtsSrvr.exe,SQLAgent90.exe,DtsDebugHos t.exe,DatabaseMail90.exe