Microsoft SQL Server forum - Linked Server SQL to SQL

Author

Linked Server SQL to SQL

tim.pascoe@cciw.ca

2006-02-25, 9:45 am

I am currently trying to set up a linked server between two SQL-Server
2000 servers. I have a number of linked servers to other machines,
which use local accounts and work fine. However, in this particular
case, I am forced to use my domain account to log into the remote
machine. My account has been added to a group on the remote machine and
has access privilages, accross domains.

I have created the linekd server and used my domain account in the
security window, set to be impersonated. I can register the remote
server in my Enterprise Manager and access the views I need. However, I
need to run distributed queries against the remote machine, and thus
need the linked server to function.

Any ideas? If there is not enough information here I'll provide more.

Thanks,

Tim

Stu

2006-02-25, 9:45 am

Well, for starters, is there a question in there somewhere? <G>

I'm assuming you have encountered the infamous double-hop error; you
can read more about it here:
http://support.microsoft.com/suppor...s/q238/4/77.asp

If that's not it, write back and let us know what problem it is you are
experiencing.

HTH,
Stu

tim.pascoe@cciw.ca

2006-02-28, 8:29 pm

Stu,

Thanks for teasing out the question, even when I forgot to put it in
:) The double-hop is definitily the issue.

Thanks,

Sponsored Links