MS SQL Server DTS - DTS Jobs across NT domains

Author

DTS Jobs across NT domains

Jeff Cochran

2005-06-29, 3:23 am

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

Narayana Vyas Kondreddi

2005-06-29, 3:23 am

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

"Jeff Cochran" <jeff.nospam@zina.com> wrote in message
news:42ca0b23.297351359@msnews.microsoft.com...
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

Jeff Cochran

2005-06-29, 8:24 pm

On Wed, 29 Jun 2005 08:56:02 +0100, "Narayana Vyas Kondreddi"
<answer_me@hotmail.com> wrote:

>See if the following guide you in the right direction:
>http://support.microsoft.com/defaul...kb;en-us;269074
>http://support.microsoft.com/defaul...kb;en-us;318819

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

Jeff

>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?

Sponsored Links