Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tjmcols
Starting Member
1 Post |
 Posted - 2009-05-20 : 10:00:39
|
| I have database mail working for sending emails to email addresses within the company domain. However, the notifications sent to email addresses outside the company domain (my personal email and cell phone) are not working. The database mail log shows an error message twice which are related to the personal and cell phone emails. The error is “The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 4 (2009-05-19T10:30:14). Exception Message: Cannot send mails to mail server. (Unable to send to a recipient.)” Here's another web post that I found and sent to our Exchange administrator that SMTP Receiver Connectors and Relay Restrictions http://msexchangeteam.com/archive/2006/12/28/432013.aspx. Maybe it will help someone else but I would like to hear if anyone has had success with these steps. |
|
|
jholovacs
Posting Yak Master
163 Posts |
Posted - 2009-05-20 : 12:58:56
|
this sounds like an issue with the SMTP server's relay settings. It probably does not trust the sql server to allow mail to relay to a mail host in a domain it does not own.
SELECT TOP 1 w.[name]FROM dbo.women wINNER JOIN dbo.inlaws i ON i.inlaw_id = w.parent_idWHERE i.net_worth > 10000000 AND i.status IN ('dead', 'dying') AND w.husband_id IS NULLORDER BY w.hotness_factor DESC |
 |
|
|
|
|
|
Database Mail - SMTP/Exchange Relay