>Hi!
> I'm a novice working with SQL Server 2000. I have to make queries using two distinct servers (local server1 and remote server2. I added a linked server on server1 but I am having problem logging to the remote server (server2). Are there options that must be setup on the remote server in order to log on to it and then make queries? Thanks a lot.
Pascal,
Take a look at
sp_addlinkedsrvlogin system stored procedure in BOL.
--sb--