Ole Db Provider Sqlncli11 for Linked Server Login Timeout Expired Linked servers allow getting information from a different SQL Server case using single T-SQL statement. This article will explain how to create, configure and drop a SQL Server linked server using system stored procedures. Likewise, in that location is a way to create and configure a linked server to another SQL Server instance using SQL Server Management Studio (SSMS). To meet how to configure a linked server by using the SSMS GUI, meet the article How to create and configure a linked server in SQL Server Management Studio. Creating a SQL Server linked server To create a linked server, employ the sp_addlinkedserver process. Executing the following lawmaking: