I have a DTS job that is giving me fits wehn run from a scheduled job.
Access denied to server. The DTS runs fine if executed directly, so I
don't believe it's the connection in DTS (using SA account on both SQL
Servers), the job fails on the first step which is the connection to
the other server.

I've tried running the job as domain admin, there is a two-way trust
between domains, and as system account, with same effect.

Any suggestions before I move one server into the other domain?

Thanks,

Jeff

See if the following guide you in the right direction:
http://support.microsoft.com/default...b;en-us;269074
http://support.microsoft.com/default...b;en-us;318819
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/


"Jeff Cochran" <jeff.nospam (AT) zina (DOT) com> wrote

I have a DTS job that is giving me fits wehn run from a scheduled job.
Access denied to server. The DTS runs fine if executed directly, so I
don't believe it's the connection in DTS (using SA account on both SQL
Servers), the job fails on the first step which is the connection to
the other server.

I've tried running the job as domain admin, there is a two-way trust
between domains, and as system account, with same effect.

Any suggestions before I move one server into the other domain?

Thanks,

Jeff

On Wed, 29 Jun 2005 08:56:02 +0100, "Narayana Vyas Kondreddi"
<answer_me (AT) hotmail (DOT) com> wrote:

Thanks. Didn't help directly, but gave me another option - using the
dtsrun.exe command line utility to run it, which worked perfectly.

Jeff