Re: Run SQL T-SQL Job Step across Different Domains

What Operating Systems are these two servers running?
What trusts, if any, are set up between the two domains?
How are you trying to connect?
What is the exact error number and error message?

-Sue

On Thu, 9 Aug 2007 08:10:09 -0700, MWD
<MWD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I have two sql 2005 servers in two different domains. I have a SQL job on
one of the servers that runs a T-SQL script that accesses databases on the
SQL box inthe other domain.

I'm getting a message in the job history that the job won't run because of
the security context.

How can I set this up?

Thanks for your help.

.