Avatar of drmonoe
drmonoe
 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?
Microsoft SQL Server 2008Exchange

Avatar of undefined
Last Comment
drmonoe

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Seelan Naidoo

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
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!
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck