Skip to content

AliasLinkedServer.md

Latest commit

 

History

History
15 lines (12 loc) · 802 Bytes

AliasLinkedServer.md

File metadata and controls

15 lines (12 loc) · 802 Bytes
Raw

Alias a Linked Server in SQL Server Management Studio

Use this checklist when you want a friendly alias instead of exposing the physical host name.

  1. In SQL Server Management Studio, open Linked Servers and choose New Linked Server.
  2. On the General tab:
    • Enter the alias in the Linked server field.
    • Select SQL Native Client as the provider.
    • Set Product Name to sql_server.
    • Set Data Source to the actual host name or approved network alias.
  3. On the Security tab, configure the required login mapping or security context.
  4. On the Server Options tab, enable Data Access, RPC, RPC Out, and Use Remote Collation if your workload requires them.

Reference: https://serverfault.com/questions/435440/alias-a-linked-server-in-sql-server-management-studio