dcsimg
Results 1 to 5 of 5

Thread: permission to send mail mail from dts

  1. #1
    Join Date
    Sep 2002
    Posts
    159

    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

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    If you are scheduling it as a Job, SQLServeragent should run on the account name which you are using it for SQLMail.

  3. #3
    Join Date
    Sep 2002
    Posts
    159
    no it is not a job .

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

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    Then you should start sql mail with domain\joe's mail profile.

  5. #5
    Join Date
    Sep 2002
    Posts
    159
    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
  •