June 29, 2010 at 7:28 pm
All 5 test emails from SQL Server 2008 on the Windows 2008 Server have failed. The error rcvd:
"The mail could not be sent to the recipients because of the mail server failure."
Based on below for TestAccount settings, does anyone see anything wrong?
Here are my settings:
Email address: aitchk.candoo@gmail.com (working gmail address)
Reply email: aitchk.candoo@gmail.com
Server Name: smtp.gmail.com
Port number 465
Basic authentication
Username: aitchk.candoo
Password: ********(password for gmail account)
I sent a test message from my comcast email account and it delivered to gmail just fine.
June 29, 2010 at 9:39 pm
hxkresl (6/29/2010)
All 5 test emails from SQL Server 2008 on the Windows 2008 Server have failed. The error rcvd:"The mail could not be sent to the recipients because of the mail server failure."
Based on below for TestAccount settings, does anyone see anything wrong?
Here are my settings:
Email address: aitchk.candoo@gmail.com (working gmail address)
Reply email: aitchk.candoo@gmail.com
Server Name: smtp.gmail.com
Port number 465
Basic authentication
Username: aitchk.candoo
Password: ********(password for gmail account)
I sent a test message from my comcast email account and it delivered to gmail just fine.
Check if the port number 587 works , most of the time port number 465 does not work.
Also, check if you have checked the SSL security and if the gmail user name and password is correct.
"More Green More Oxygen !! Plant a tree today"
June 30, 2010 at 1:36 pm
made the advised changes (port 587 and SSL security checked). Getting same error:
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2010-06-30T12:26:45). Exception Message: Cannot send mails to mail server. (The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.5.1 Authentication Required. Learn more at ). )
How can I verify the following?
The SMTP server requires a secure connection or the client was not authenticated.
msdn.microsoft states:
"Database Mail considers mail to be sent, when it is successfully delivered to a SMTP mail server. Subsequent errors, such as an invalid recipient e-mail address, can still prevent mail from being delivered, but will not be contained in the Database Mail log.
".
From this I am thinking that the email hasn't left SQL Server yet and there is a problem with the configuration on my end such as port number.
Any other ideas, friends?
June 30, 2010 at 8:19 pm
Minaz Amin, thank you for getting me to this point.
And folks, gmail works. Just make sure to put your gmail email into the user name field, not just the username.
Like this:
Email address: aitchk.candoo@gmail.com (working gmail address)
Reply email: aitchk.candoo@gmail.com
Server Name: smtp.gmail.com
Port number 587
Basic authentication
Username: aitchk.candoo@gmail.com
Password: ********(password for gmail account)
a good post on this is here:
http://www.sqlservercentral.com/Forums/Topic690626-146-1.aspx
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply