Database Mail SQL 2005

Question

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....

 

Answer 1

I have the same problem,

Help please!!!!!!

Answer 2

What about testing the sending of Emails using telnet ?

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

Answer 3

yea, got the same problem.  We need help with this issue and not a direction to telnet. Thanks

Answer 4

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
---

Answer 5

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

Answer 6

GUYS!!!!!!

It WORK!!!

See:

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

Answer 7

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

 

Answer 8

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:

 

[e-mail];[e-mail];[e-mail];[e-mail];[e-mail]

 

 

Answer 9

you're perfect

Answer 10

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:

Answer 11

Has anyone found a solution to this yet?  I have having the same issue and have tried numerous things from a bunch of forums.

 

Thanks

Answer 12

Hai for me also same problem. Am using gmail account with port 465. Am able to telnet to this port. Also from iis mail is working. Only from sql server its not working .
Other mail accounts from SQL server is working. Only gmail account is not working. I have tried with secured line as checked, but still not working.


Please help

Answer 13

hai some prob wit gmail. wen i chked with other two mail server it worked for. Only with gmail account its not working

Answer 14

did you check the surface area configuration for SLQMAILEnabled property? it must be set to true.