Monday, July 18, 2011 11:57 AM
I need a little help here, i want to send email from sql server with database mail service. As i dont have any private mail server, so i try to use public smtp such as gmail,yahoo, or live mail.
as i find a walkthrough to doing this things,
i thought it is possible for sending test mail to external/public mail, but i always find error results in database mail log.
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2011-07-18T18:11:21). Exception Message: Could not connect to mail server. (A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 220.127.116.11:587).
I also try to change any possible port for smtp.gmail.com : 465 (using ssl) or 587 (using tls) or using smtp.live.com : 25 with ssl require cheked.
It is possible for configuring database mail with public smtp/mail server?
Very appreciate and thanks for any responses
Friday, October 14, 2011 1:59 PM
Have you ever found a solution for this?
I have the same problem
Friday, October 14, 2011 2:45 PM
Can you connect from a mail client to these services with the same ports from that computer? I'm/was able to use Gmail for database mail. Sometimes ISP's block some ports (eg 25) or your firewall blocks all these.
I hope it helps.
There are 10 type of people. Those who understand binary and those who do not.
Friday, October 14, 2011 3:06 PM
Yes I can connect using telnet + open stmp.gmail.com 587
Also SSIS (Sql Server Integration Services) connects fine.
Thanks for the suggestion though, any other idea?