Get 'Unable to relay' When SQL Server Sends Mail to Non-Domain Address 1

[JohnBates]

hi Exchange experts,

I don't know if this is an Exchange problem or something else... here goes:

We use Exchange 2007 and the mail server has IIS 6 and Windows 2003.

This is the first time I've needed to send an automated email to an address that's outside our domain.

I run the following SQL Server 2005 statement - see the error below.

EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'PNCLRMDB',
@Recipients = 'MyPhonenumber@vtext.com',
@body = 'Sent by sp_send_dbmail to MyPhonenumber.com',
@Subject = 'Test text message notification from SQL Server PNCLRMDB';

The error log shows:
Error,132,The mail could not be sent to the recipients because of the mail server failure. (Sending Mail Cannot send mails to mail server. (Mailbox unavailable. The server response was: 5.7.1 Unable to relay).

The digging I've done seems to indicate that the problem is with the Exchange configuration. But if that's true, why am I able to send email from my desktop Outlook to non-domain addresses?

Can anyone tell me how to set Exchange 2007 to allow emails out to non-domain addresses?

Thanks, John

 

[xmsre]

Allow the IP address of the SQL server to relay. "create a receive connector to allow anonymous relay for a specific source IP" in

http://technet.microsoft.com/en-us/library/bb232021.aspx