Mailbox unavailable. The server response was: 5.7.1 Client does not have permissions to send as this sender

Posted By Mostafa Elzoghbi On 09 Jun 2010 08:06:17

Tag : Sql Servers

Digg del.icio.us Newsvine Facebook Google MySpace Reddit Twitter Windows Live YahooBuzz FriendFeed

No of Views	:	9115
Bookmarked	:	0 times
Votes	:	0 times

Introduction

I was trying to send Emails using SSIS package deployed in SQL 2008. I was getting this error when i am trying to run the SQL Agent Job which sends Email address on the success of this job.

Error message in event log

Mailbox unavailable. The server response was: 5.7.1 Client does not have permissions to send as this sender.

To fix this problem check the following

1) Check the service account for SQL Agent Service in your server.

2) Make sure the service account is a domain account, because if the system administrator doesn't allow to send emails for anonymous users, then this is one of the main reasons to get this error.

3) Don't forget to restart the SQL service agent if you changed the service account.

4) Inform your system administrator to add anonymous users with a new receive connector in Exchange, check this article:

http://computermutt.wordpress.com/2009/09/02/smtpexception-mailbox-unavailable-when-sending-from-web-page/

5) Make sure in your SSIS Package you check use windows authentication checkbox in the SMTP Connection manager.

Hope this helps.


Other popular Tips/Tricks
How to ALTER or ADD two columns in Sql Server Table using T-Sql In this tips, I will explain how to ALTER or ADD two or more columns in to table by t-sql script. Published Date : 25/Mar/2011 Tracking Change Data Capture in SQL Server 2008 A very important feature of SQL Server 2008 is that we can enable CDC(Change Data capture) on database or table.We can track the database had CDC enabled by querying IS_CDC_ENABLED column Published Date : 17/Jan/2011 Tracking Change Data Capture in SQL Server 2008 A very important feature of SQL Server 2008 is that we can enable CDC(Change Data capture) on database or table.We can track the database had CDC enabled by querying IS_CDC_ENABLED column Published Date : 17/Jan/2011 How to use DATEDIFF() function in Sql Server This is the third tips date related function in sql server. In this I going to show you how to use DATEDIFF() function in sql server. The DATEDIFF () is useful to get the specified date part between two dates Published Date : 16/Dec/2010 How to get Table and Database size using T-Sql Today I would like to check my database and other few table size in online database. For that I have been use the system produce to get the tables and database size. Published Date : 15/Dec/2010

Comments

There is no comments for this articles.