SQL Server Management Studio

Right click “Linked servers” and select “New linked server…”

General

Provider select “SQL Server Native Client 11.0”

Security

Select “Be made using this security context” and input “remote login” and “with password”

Server Options

Select items are “true”

×