Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-31 : 08:17:30
|
| Chris writes "2 node cluster, windows 2000 advanced server SP2SQL Server Enterprise Edition SP2error from sql shown below....Executed as user: SPICERS-SQL\sql. ...Start: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 314 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 314 DTSRun OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSDataPumpTask_2 DTSRun OnProgress: DTSStep_DTSDataPumpTask_2; 314 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 314 DTSRun OnFinish: DTSStep_DTSDataPumpTask_2 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: sqldts8... Process Exit Code 1. The step failed.....this runs through to a successful completion when run on a remote computer via Enterprise Manager but not when submitted as a job.I have logged onto the server via Terminal Services as sql and have run the DTS package and I can see that it is the account properties that are at fault.I have checked Outlook2000 and sql has a mapi profile and I have checked Exchange(this exists on another domain) and can see that sql has permissions on the mailbox in question(seen below).user=send as, mailbox owner.I have searched on the internet and seen requests for help of a similar nature, but they all seem to be about if the account has a mapi profile or not.Help!RegardsChris Caselton" |
|
|
autiger
Starting Member
1 Post |
|
|
|
|
|
DTS MAPI Logon Error 