permission to send mail mail from dts

[alex]

hello everybody.

I have server server1
sql server and agent and mail profiler
running using mydomain\svcsql

dts (test_dts)created by user domain\alex
with "use windows athentication"

dts steps
1. exe sp_who2
2. send mail to joe



user domain\joe run
DTSRun /S server1 /E /N test_dts
with error
Error: -2147220352 (80040480); Provider Error: 0 (0) Error string: Logon failed: MapiLogonEx Failed due to MAPI error 273: MAPI Logon failed

what permisissions should be granted to
domain\joe
in order to run dts from DTSRun ?


Thank you

[MAK]

If you are scheduling it as a Job, SQLServeragent should run on the account name which you are using it for SQLMail.

[alex]

no it is not a job .

Dts will be called from computer x
by user mydomain\joe using dtsrun at anytime

[rmiao]

Then you should start sql mail with domain\joe's mail profile.

[alex]

So, if any dts contain xp_sendmail it could run only under account that was specified by mail profiler?