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