troubleshooting Question

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

Avatar of drmonoe
drmonoe asked on
ExchangeMicrosoft SQL Server 2008
3 Comments1 Solution431 ViewsLast Modified:
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
Microsoft Systems Admin

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros