Re: jobs for a linked server in a different domain?

From: Chieko Kuroda (ckuroda_at_unch.unc.edu)
Date: 07/13/04 

Date: Tue, 13 Jul 2004 08:15:08 -0400

Thanks for staying with me.
Okay the Service startup account is pccm/ckuroda
and the sql server connection is windows authentication.
when open query analyzer I'm using pccm/ckuroda account and the results of
the query are 460 rows affected with the results displayed.
Chieko
"Mark Allison" <marka@no.tinned.meat.mvps.org> wrote in message
news:eaQLUHLaEHA.3664@TK2MSFTNGP12.phx.gbl...
> Chieko,
>
> What account does SQLAgent use to log on now?
> Use that account explicitly to log on to the server console.
> Run your query.
>
> Paste your results here.
>
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
>
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
>
>
> Chieko Kuroda wrote:
> > Mark,
> > I tried to change the service account that the agent uses to start and
run
> > jobs as but I can't choose a name from a different domain. I'm not sure
if
> > I'll be able to get to that domain from the services gui.
> > Chieko
> > "Chieko Kuroda" <ckuroda@unch.unc.edu> wrote in message
> > news:%23xvT8FCaEHA.1508@TK2MSFTNGP09.phx.gbl...
> >
> >>Mark,
> >>using the windows account the select query works fine.
> >>But I understand what your saying about a permissions issue.
> >>Chieko
> >>"Mark Allison" <marka@no.tinned.meat.mvps.org> wrote in message
> >>news:%239En%23uBaEHA.596@TK2MSFTNGP11.phx.gbl...
> >>
> >>>Chieko,
> >>>
> >>>No, don't log in using sa. Log in using the Windows account that SQL
> >>>Agent uses, then run the query. What happens?
> >>>--
> >>>Mark Allison, SQL Server MVP
> >>>http://www.markallison.co.uk
> >>>
> >>>Looking for a SQL Server replication book?
> >>>http://www.nwsu.com/0974973602.html
> >>>
> >>>
> >>>Chieko Kuroda wrote:
> >>>
> >>>>Mark,
> >>>>Thanks for reading my posted question. the job history just says that
> >>
> >>the
> >>
> >>>>job failed but no reason why. I tried to log into the query analyzer
> >>
> >>using
> >>
> >>>>the sa account but I'm getting a non trusted connection error message.
> >>>>However, I'm using windows authentication for everything.
> >>>>Thanks again,
> >>>>Chieko
> >>>>"Mark Allison" <marka@no.tinned.meat.mvps.org> wrote in message
> >>>>news:u8Ol99AaEHA.3420@TK2MSFTNGP12.phx.gbl...
> >>>>
> >>>>
> >>>>>Chieko,
> >>>>>
> >>>>>What error message do you get? Can you log into query analyzer using
> >
> > the
> >
> >>>>>SQLAgent service account details and run the query again? Please post
> >>>>>the error message.
> >>>>>
> >>>>>--
> >>>>>Mark Allison, SQL Server MVP
> >>>>>http://www.markallison.co.uk
> >>>>>
> >>>>>Looking for a SQL Server replication book?
> >>>>>http://www.nwsu.com/0974973602.html
> >>>>>
> >>>>>
> >>>>>
> >>>>>Chieko Kuroda wrote:
> >>>>>
> >>>>>
> >>>>>>Hello,
> >>>>>>I have this t-sql statement:
> >>>>>>
> >>>>>>Select * from tbl_Hobo...tblHobo where age<19 and admitdate>
> >>>>
> >>>>Getdate()-71
> >>>>
> >>>>
> >>>>>>go
> >>>>>>Where tbl_Hobo is a linked server in a different domain.
> >>>>>>I can run the statement in the query analyzer just fine, but when I
> >>>>
> >>>>create a
> >>>>
> >>>>
> >>>>>>job to run the same query it fails and I'm not sure why.
> >>>>>>I'm using the same username and password in both situations and the
> >>>>
> >>>>linked
> >>>>
> >>>>
> >>>>>>server is on a mapped drive.
> >>>>>>Any suggestions?
> >>>>>>Thanks so much,
> >>>>>>Chieko
> >>>>>>
> >>>>>>
> >>>>
> >>>>
> >>>>
> >>
> >
> >

Relevant Pages