Create linked server in SQL Server with SSMS

Create a linked server in SQL Server with SSMS 

This post shows how to use T-SQL or SQL Server Management Studio (SSMS) to create a linked server and access data from another SQL Server or other data source. The SQL Server database may read data from external data sources and issue commands to external database servers thanks to linked servers, which are independent of the SQL Server instance.

Create a linked server with SSMS using the following procedure:

In SQL Server Management Studio (SSMS):

·       Open Object Explorer.

·       Expand Server Objects.

·       Right-click Linked Servers.

·       Select New Linked Server.

 

        

     

·       Select Security Tab.

 

·       Click OK.

 

After Completed the process, linked server created successfully.

Note: If it is throwing an error, you just need to keep few things in mind:

1.     Please check remote server “SQL server configuration manager”

        ·      Named Pipe    

        ·      TCP

2.     Check SQL Port

3.     Check Firewall