January 8, 2002 at 9:55 am
I have several dts packages that run just fine through a third party scheduler. I then put a mail task on them to tell me if the package succeeded or failed. Every time the scheduler gets to the mail task it fails and logs a mapi login failure error. When I execute the dts package on my local box it sends the email with no problems. is it a problem with the robot login or is it associated to the profile? any help would be greatly appreciated.
Elizabeth
Elizabeth
Elizabeth
January 8, 2002 at 10:20 am
When you execute the package, it runs under the context of your login and from your workstation. When it runs from the scheduler, it runs as the SQLAgent service account from the server. This account may not be able to login to the mail server. You should verify permissions. You can log into the server as the SQLAgent account and test it that way.
Steve Jones
January 8, 2002 at 10:27 am
Anytime that you are working with Send Mail from a DTS package there are four points to check as follows;
1. The job that is running the DTS package owner.
2. The profile referenced by SQL Server Agent.
3. The profile referenced by the Send Mail task.
4. The profile referenced by the Mapi Client (Outlook).
If all four match, you should be fine. Hope this helps.
If this is a 7.0 install, you should also check the SQL Mail "service" under Support Services.
Hope this helps.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 8, 2002 at 11:58 am
Thanks. I will check that out now. Do you have to have outlook installed on the box that the main sql server is on?
Elizabeth
Elizabeth
Elizabeth
January 8, 2002 at 12:04 pm
Yes. Glad to help.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 8, 2002 at 12:51 pm
ok. the profile name is sqlserver. it is on each of the three locations (sql server agent, send mail task, and outlook). I see what you guys are saying about the package running under the context of my account versus the scheduler account. The scheduler runs the package under the dtsrun account. I guess I just don't fully understand the #1 thing David wrote. Where do I verify that dtsrun has the appropriate permissions with mail? I also can't seem to find the sqlagent account in the computer manager. is that a problem?
Elizabeth
Elizabeth
January 8, 2002 at 3:45 pm
the account under which sql agent run is in the control panel/services. This account should be setup like a normal user in the Exchange server.
Steve Jones
January 8, 2002 at 3:55 pm
GOT IT! YEAAA! Thank you all so much!
Elizabeth
Elizabeth
Elizabeth
January 8, 2002 at 3:59 pm
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply