Skip to content

new-alias-alias-tab.md

Latest commit

 

History

History
53 lines (37 loc) · 3.41 KB

new-alias-alias-tab.md

File metadata and controls

53 lines (37 loc) · 3.41 KB
title New Alias (Alias Tab)
ms.custom seo-lt-2019
ms.date 03/14/2017
ms.prod sql
ms.prod_service sql-tools
ms.reviewer
ms.technology configuration
ms.topic conceptual
ms.assetid 785eb6fb-f67e-449d-b1c8-c38dfbb95ef6
author markingmyname
ms.author maghan
monikerRange >=sql-server-2016||=sqlallproducts-allversions

New Alias (Alias Tab)

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md-winonly] An alias is an alternate name that can be used to make a connection. The alias encapsulates the required elements of a connection string, and exposes them with a name chosen by the user. Use the Alias page on the Alias - New dialog box to specify the elements of the connection string for an alias. To change the connection string of an existing alias, see <Alias> Properties (Alias Tab).

All values in the Properties grid do not have to be completed. Valid combinations vary depending on the protocol selected. See the topics listed below for examples of valid combinations.

Alias Name
The name (alias) that you want to use to refer to this connection.

Pipe Name / Port No
Additional elements of the connection string. The name of this box varies with the selected protocol.

Protocol
The protocol used for the connection.

Server
The name of the [!INCLUDEmsCoName] [!INCLUDEssNoVersion] instance being connected to.

When to Use an Alias

By default, [!INCLUDEssNoVersion] connects to a local instance of [!INCLUDEssNoVersion] using the Shared Memory protocol, and to an instance of [!INCLUDEssNoVersion] on another computer using either TCP/IP or Named Pipes. Create an alias when you are using TCP/IP or named pipes, and you want to provide a customized connection string, or when you want to use a name other than the server name for the connection.

Examples

  • [!INCLUDEssNoVersion] is not listening on the default TCP/IP port of 1433 so you want to provide a connection string with a different port number.

  • [!INCLUDEssNoVersion] is not listening on the default named pipe so you want to provide a connection string with a different pipe name.

  • An application expects to connect to a database on the server named ACCT, but that database has been consolidated as an instance named ACCT on a server named CENTRAL. The application cannot easily be changed. Create an alias named ACCT, with a connection string pointing to CENTRAL\ACCT.

Creating a Valid Connection String

See the following topics for a description and examples of valid combinations of alias properties: