I want to pull some data into my queries from a remote server (also SQL Server 2008), because some related data is on the remote server but not the local server.
The "add linked server" wizard in SQL Server 2008 asks me for a "Linked Server Name", so I make up a name like "remote_server_name". It also asks me to choose the server type, so I choose "SQL Server" for the server type, because that's what it is.
Where do I specify the IP address or domain name of the remote server? Where do I specify the instance name? It tells me the connection fails, well obviously because it never asked me where the server is located or what its instance name is. It happens to be the default instance that I want to connect to on the remote machine.