⭐Sql Server Create Linked Server

Sometimes it is necessary to access another database which is in another instance. To solve it we can create a linked server by linking Server A to Server B.

Create Linked Server

Then we will create a linked server using SSMS (SQL Server Management Studio), following the Next steps:

1. We enter Server Objects --> Linked Servers --> and we right click on New Linked Server as shown in the following image:

2. Then it shows us a window to configure the new linked server, see below:

Linked Server Configuration

• In Linked server we type a descriptive name
• In server type, we select Other data source, the option Sql Server forces to type the exact name of the server Sql server.
• We select as provider: Microsoft OLE DB Provider for SQL Server
• In Data source we digitize the name of the server and the instance
• Provider string we leave it blank

Configure Linked Server Security

The security of the linked server can be done by these options:

• Be made using the login’s current security context
• Be made using this security context
• Local server login to remote server login mappings
• Not be made
• Be made without using a securi ty context

For this example we select: Be made using this security context

Post Popular

• CSV to Sql

Then we digitize the user created on the other server with the need to link and digitize their password and click on OK.

With these simple steps the Link server has been created.

Share: