Re: jobs for a linked server in a different domain?
From: Chieko Kuroda (ckuroda_at_unch.unc.edu)
Date: 07/14/04
- Next message: Julie: "Activity on a database?"
- Previous message: Julie: "Security Patches hammer SSL for SQL Server"
- In reply to: Mark Allison: "Re: jobs for a linked server in a different domain?"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 14 Jul 2004 15:11:44 -0400
Mark,
Some time last week I had tried to adjust the security settings for the
linked server but that presumes that there is a username and password on the
Access database which is not the case. I don't have control over the second
domain where the Access database is located, so I can't change anything on
the linked server. I think that I might try copying the table from the
second domain to a network drive on my domain and then transferring the
information to sql server.
Thanks for the help anyway.
Chieko
"Mark Allison" <marka@no.tinned.meat.mvps.org> wrote in message
news:uAp%23mXXaEHA.1764@TK2MSFTNGP10.phx.gbl...
> Chieko,
>
> If that works then the linked server should also work. What are the
> linked server settings when you right click the linked server and click
> on the Security tab? Try "Be made using the login's current security
> context"
>
> If that doesn't work then you might want to try connecting using
> standard SQL security on your remote server. To do this, set the remote
> server to Mixed Mode (beware of the security implications of doing this
> - it reduces your security slightly), create a login on the remote box,
> and then use this login in your linked server definition. Select the "Be
> made with this security context" option and enter the username and
password.
>
> Does that work? You might want to test the last step by loggin into
> Query Analyzer using the linked server login you just created and
> running your query. If that works, then the linked server should work.
>
> Let us know how you get on.
>
> --
> 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:
> > 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
> >>>>>>>>
> >>>>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>
> >
> >
- Next message: Julie: "Activity on a database?"
- Previous message: Julie: "Security Patches hammer SSL for SQL Server"
- In reply to: Mark Allison: "Re: jobs for a linked server in a different domain?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
