asked on

SQL 2008 SMTP Returns Error 5.7.1 When Trying to Send Mail Via Exchange 2007

I'm trying to configure a SQL instance to send mail to an internal recipient. Using the database configuration wizard, the following settings have been made:

Email Address: sqlservice@companyname.com
Display name: blank
Reply e-mail: sqlservice@companyname.com

port number: 25

This server requries a secue connection field: unchecked

Windows Authentication using Database Engine service credentials: checked

(of course, basic auth and anonymous auth are blank)

...

The sqlservice account has a mailbox on our Exchange 2007 server.

Attempts to send test messages produce the following error:

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2011-08-11T16:50:06). Exception Message: Cannot send mails to mail server. (Mailbox unavailable. The server response was: 5.7.1 Client does not have permissions to send as this sender).

As near as we can tell, all settings on the SQL 2008 and Exchange 2007 sides of things are correct. Anyone have additional troubleshooting tips/ideas as to why this is failing?

ASKER CERTIFIED SOLUTION

Seelan Naidoo

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

drmonoe

ASKER

I'm away from the console now but will check these properties and report back tomorrow.

drmonoe

ASKER

Allowing connections from the SQL server via Exchange's receive connector did the trick.

Thanks!