Database Mail SQL 2005

I'm having a problem with database mail in SQL Server 2005. I have set up a default profile. My SMTP server is not a localhost instead i've fed SMTP ip address and port no. The same setting in Outlook express works fine for Incoming and outgoing mails. but in SQL 2005 i'm not able to send test emails. The following errors show up in the sql server agent log

Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2006-06-13T10:47:27). Exception Message: Could not connect to mail server. (An established connection was aborted by the software in your host machine).
)

Please help me out....

I have the same problem,

Help please!!!!!!

|||What about testing the sending of Emails using telnet ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||yea, got the same problem. We need help with this issue and not a direction to telnet. Thanks|||Yes, sure but telnet will help you to see which error the SMTP server is throwing back during the sending of the message. I don′t want to instruct you using telnet, but thats often the best way to debug the communication.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||i've got the same problem on 64-bit version.
but outlook has sent the e-mails from this computer.

i cannot find in internet some clarifying answer about this problem|||GUYS!!!!!!

It WORK!!!

See:

Database Mail in SQL Server 2005
www.databasejournal.com/features/mssql/article.php/3626056|||

hii

sending mail is worked. now i need to send the mail to multirecipients from a table. how could we do that? thank you very much

|||

Hi,

I would use something like this:

use adventureworks

Declare @.Recipients varchar(4000)

select @.Recipients = coalesce(@.Recipients + ';' , '' ) + emailAddress

FROM Person.Contact

PRINT @.Recipients

The results:

a0@.adventure-works.com;a1@.adventure-works.com;aaron0@.adventure-works.com;aaron1@.adventure-works.com;aaron10@.adventure-works.com

|||you're perfect |||Drat - that didn't fix it for me, I still get:

Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 5 (2007-06-12T10:46:15). Exception Message: Cannot send mails to mail server. (The operation has timed out.).
)

Outlook express can send fine. I am trying to use a gmail account configured using these settings: