Sunday, March 06, 2011 4:27 AM
I had configured the email in my Database mail and it worked about a month ago. Yesterday i wanted to test it again and now it just will not work. The email settings are exactly the same as my outlook and they work fine from the outlook, so it is not an issue with my account. I have tried almost everything to troubleshoot this without any success . I deleted my old email account/profile, etc. Restarted my sql server, agent and reconfigured my email address.Here is the error I am getting. Please advise.
The mail could
not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2011-03-05T18:37:26). Exception Message: Cannot send mails to mail server. (Failure sending mail.). )
I am sending this from my laptop and logged in as sa when I send it. Furthermore, the account associated with the profile is member of databasemailuserrole.
Tuesday, March 08, 2011 6:16 AMModerator
According to the error message, this issue has nothing to do with SQL Server Database mail. I think we can refer to the following suggestions:
1. The SMTP server name and the port number are properly.
2. Port number is not blocked by firewall.
3. Basic Authentication is used and the user name and password is entered properly.
For more information, please see:
How to configure SQL Server Database Mail
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Tuesday, March 08, 2011 11:41 PM
I am able to send emails with the same authentication from my outlook. The port is not blocked and the credentials are the same as in my outlook and it is working fine.
Any other suggestions.
Monday, March 14, 2011 8:07 AMModerator
Monday, March 14, 2011 3:44 PM
yes it is correct.