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: email@example.com
Display name: blank
Reply e-mail: firstname.lastname@example.org
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?