Posted by tim.pascoe on 02/23/06 22:29

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

[Back to original message]