SQL Server DBA Tutorial 115-How to Create Linked server in SQL Server

In this video you will learn how to create Linked Server in SQL Server using SQL Server Management studio as well as T-SQL Script. It also explains best practices of creating Linked servers in SQL Server, when it is best idea to create linked server, requirement of remote synonyms to have Linked server created. Security best practices of Linked server and how to create linked server using other providers such as ODBC, SSAS and SQL Server client 11.0.

blog post link for this video:

Visit our website to check out SQL Server DBA Tutorial Step by Step

[manjunathah]

Hi TB's,
Many thanks for such useful and easily understandable videos.
Keep updating videos.
Thank you so much.

[ganeshlv]

Thanks TechBrothersIT! Its really helpful.

[curiosityguy]

First search hit was this video. Amazing to be also the most useful. Thank you

[RAZR_Channel]

Nice Vid... thanks for taking the time.

[KalugampitiyaJayakody]

This video is very informative to create link database to sql

[zakariajaadi]

I have a SQLServer instance on ubuntu (on my VM) and i want to create a linkedserver to link this instance with another one that exists on the SQL server that is installed on the host machine (Windows), is it possible ?

[sridharg]

Could you please tell me how to create trigger between those databases? anyone?

[arielespindola]

Thank you but, it would be great if you show how to create a linked server from SQL Server 2014 to MySQL by OLE DB driver!

[vimalprince]

Can other users access the linked server or just the user we created can access it?

[rakeshbhatia]

i have a question i have created the link server but when i try to run a store procedures its does noting just keep showing executing query is there any permission i need to check bcoz i am login with sysadmin but i am unable to update any script

[ashokkumarperumal]

Msg 7314, Level 16, State 1, Line 1
The OLE DB provider "SQLNCLI11" for linked server "x.x.x.x" does not contain the table ""DNname"."user".".tablename "". The table either does not exist or the current user does not have permissions on that table.

am getting this error, kindly help to solve this issue

[anandreddy]

Is there a way to generate scripts for linked server dynamically

[shoaibsalmani]

Do we require port opening SQL server is in different subnet

[saliht.]

Hi,
is the linked server supposed to be on the same network? Or can you link to a server on a distant computer?