What should I enter in the Data Source field when setting up a Linked Server?
If connecting to SQL Server on the same machine, enter the server name. If connecting to a remote SQL Server over the network, enter the IP address or hostname of that server.