-
permission to send mail mail from dts
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
-
If you are scheduling it as a Job, SQLServeragent should run on the account name which you are using it for SQLMail.
-
no it is not a job .
Dts will be called from computer x
by user mydomain\joe using dtsrun at anytime
-
Then you should start sql mail with domain\joe's mail profile.
-
So, if any dts contain xp_sendmail it could run only under account that was specified by mail profiler?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|