From: VirtuallyNotHere on
Hello,
I can get my sql 2008 dbmail to send to internal recipients, but it fails
for any external recipients. I have tried numerous receive connector
settings and no luck. This doesn't seem to be well documented on the net,
however I did find that anonymous should work, but I don't like the idea of
setting the receive connector with the external secured permission.
How do I setup the connector? I can't setup another smtp server, and I
can't change the sql service account as it runs under the local system.

This is used for various sql maintenance job emails, alerts, and so forth.
The operator that is setup has a valid domain email address and the profile
in the dbmail is setup using a distribution list as the to & from address in
the sqldbmail.


From: Rich Matheisen [MVP] on
On Wed, 19 May 2010 15:24:01 -0700, VirtuallyNotHere
<VirtuallyNotHere(a)discussions.microsoft.com> wrote:

>Hello,
>I can get my sql 2008 dbmail to send to internal recipients, but it fails
>for any external recipients. I have tried numerous receive connector
>settings and no luck. This doesn't seem to be well documented on the net,
>however I did find that anonymous should work, but I don't like the idea of
>setting the receive connector with the external secured permission.
>How do I setup the connector? I can't setup another smtp server, and I
>can't change the sql service account as it runs under the local system.

Create a 2nd Receive Connector and put just the IP addresses into the
"Network" tab that you want to use that connector.

http://technet.microsoft.com/en-us/library/bb232021(EXCHG.80).aspx

The Ms-Exchange-SMTP-Accept-Any-Recipient permission is the key to
allowing your SQL server to sent to external addresses without having
to authenticate.
---
Rich Matheisen
MCSE+I, Exchange MVP