December 3, 2012 at 8:44 am
All,
A week ago some outside consultants upended my world. They switch the e-mail server from "tom" to "katherine". We have tested e-mailing from SQL server and it works fine. We changes the server name from "tom" to "katherine" within the dtsConfig file. However we get the following error:
Microsoft (R) SQL Server Execute Package Utility
Version 10.0.5500.0 for 64-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 8:54:15 AM
Error: 2012-12-03 08:54:50.21
Code: 0xC002F304
Source: Send Summary Mail Send Mail Task
Description: An error occurred with the following error message: "Mailbox unavailable. The server response was: 5.7.1 Client does not have permissions to send as this sender".
End Error
Warning: 2012-12-03 08:54:50.22
Code: 0x80019002
Source: Package Cleanup
Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specifie
Any suggestions?
Thanks in advance
Charles
SQL 2008
December 5, 2012 at 3:49 am
It seems to be some sort of permission issue.
Which account is used to run the SSIS package?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 3, 2013 at 2:09 am
I had a similar problem with a new mail server being implemented... the thing was additional updates were done at the same time.
It sounds similar so the link below may help
Steve
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply