Can someone please explain me how to connect from my SQLServer to a remote SQLServer. Both the servers are 2000. I have tried linked servers but it is quite confusing.
Thanks,
First, you need to resolve any connectivity issues between the two servers. Is the remote SQL server on a host that can be resolved via DNS, or do you have to specify an IP address? Are they on the same subnet? Is the remote server listening on port 1433 for requests (Network Configuration applet)?
If you only have an IP address, then I suggest using the Client Configuration applet to create an alias for the remote server and map it to the IP address and port number.
Once your connectivity issues are resolved, adding a linked server is a snap; if they are in different domains that have no trust relationship, you have to use native SQL server authentication; otherwise, if one server can access the same Active Directory as the other, you can use Windows authentication.
Hope this helps. Please post additional details if you need additional help.
Cheers!