Take the 2-minute tour ×  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.  share|improve this question  1 Answer
1  up vote 1 down vote accepted  If you're using the wizard and
selecting "SQL Server" as the server type then you need to
provide the instance name of the remote SQL server as the value
for Linked Server Name. This w