November 29, 2006 at 2:02 pm
Hello,
I have a scheduled job that runs a dts package. The dts package has one task: A send mail task, where an Excel spreadsheet is attached. The job fails with the following error in the Job History;
Executed as user: CDN.BW.DOM.1\1sqldev. DTSRun: Loading... DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSSendMailTask_1 DTSRun OnError: DTSStep_DTSSendMailTask_1,
Error = -2147220352 (80040480) Error string: Logon failed: MapiLogonEx
Failed due to MAPI error 273: MAPI Logon failed. Error source:
Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp
Help context: 9100 Error Detail Records: Error: -2147220352 (80040480);
Provider Error: 0 (0) Error string: Logon failed: MapiLogonEx Failed due to MAPI error 273:
MAPI Logon failed. Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp Help context: 9100 DTSRun OnFinish: DTSStep_DTSSendMailTask_1
DTSRun: Package execution complete. Process Exit Code 1. The step failed.
I have done some research on this, and the following are my findings;
-1sqldev is a domain account
-the account is a member of local administrators on the sql server box.
-I can manually run the dts package from my workstation (sql server is on another box), and I have an Exchange account.
-the file attachment is on another server. i tried to copy the file to the local sql server, reconfigured the send mail task to point to the file in the new location. The job still failed with the same error.
-SQL Agent service is started with the 1sqldev domain account.
-The SQL Server Agent and SQL Mail mail profiles both use 1sqldev, and when the profiles are tested, the test 'successfully starts and stops a MAPI session' with the profile.
-The mail client is MS Outlook 2000. The email programs in the IE browser are set up for this client.
-The mail profile on the sql box, and set up for MS Outlook 2000 client is SQLDEV. It is an alias for 1SQLDEV.
What else could the problem be?
Thank you for your help!
CSDunn
November 29, 2006 at 2:33 pm
This might help : BO
SQL Mail and SQL Agent Mail sessions may be configured to use the same Windows NT 4.0 or Windows 2000 domain user account. When using the same domain account, SQL Mail and SQL Agent Mail can share the same mail profile using a common mailbox.
SQL Server uses two separate mail sessions:
SQL Server uses this mail session when database applications execute the xp_sendmail extended stored procedure to send a message or query result set to a recipient.
Vasc
November 30, 2006 at 8:44 am
Thanks for your input. Yes, we do have this configuration. We have one domain user account that runs the services for SQL Server and SQL Server agent. The account has an account on the Exchange server. The Send Mail task in the DTS package will execute successfully when the package is not run from the Job. When run from the Job, the package fails with the error in my original post.
I'm wondering now if the password for 1SQLDEV has been changed.....
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply