create linked server in sql server 2008 r2

Muhammad younas

13y3.9k

i want to create linked server to access data from remote pc. i folowed http://msdn.microsoft.com/en-us/library/aa560998.aspx
but it gives error.error locating server . time out error.
server not found or failed to connect to server.check if remote server is set to allow remote connections.
can anyone help me step by step.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

vipul sachan12y ago
Create a linked server is quite simple. Follow the below steps-
Step 1 – Connect SQL server, using 'Database Engine' as server type along with proper Server name and authentication.

Step 2 – Into object explorer, navigate to linked server under '**Server Objects**'.

Step 3 – Right click on 'Linked Servers' - select '**New Linked Server**'. Fill all the required detail in respective dialog.

Step 4 – After filling the entire details click on Ok button, Linked server is configured and it should work. In case if it doesn't respond, once restart the SQL server.

For more detail click here
Sanjeeb Lenka13y ago
refer to this link:

http://www.c-sharpcorner.com/uploadfile/suba.venkat/linked-server-concept-in-sql-server/

http://www.c-sharpcorner.com/uploadfile/suthish_nair/linked-servers-in-sql-server-2008/

http://sqlserverplanet.com/dba/how-to-add-a-linked-server
Riyaz Akhtar13y ago
Check this link:

http://www.c-sharpcorner.com/uploadfile/suthish_nair/linked-servers-in-sql-server-2008/