cannot send email from 2008 sql server

Question

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.

Thanks

---

nfp

Answer 1

Hi,

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

Thanks,
Ai-Hua Qiu

---

Ai-hua Qiu[MSFT]
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.

Answer 2

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.

Thanks

 

---

nfp

Answer 3

Hi,

Could you please check wether the server name is correct?

Thanks,
Ai-Hua Qiu

---

Ai-hua Qiu[MSFT]
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.

Answer 4

yes it is correct.

thanks

---

nfp