Endpoints

Chapter 15 DBMS-Specific Features

An endpoint encapsulates a transport protocol and a port number, and enables SQL Server to communicate over the network.

You can create an endpoint in any of the following ways:

Select Model→EndPoint Objects to access the List of EndPoints, and click the Add a Row tool
Right-click the model or package in the Browser, and select New→EndPoint

You can modify an object's properties from its property sheet. To open an endpoint property sheet, double-click its Browser entry.

The following extended attributes are available on the Microsoft tab:

Name	Description
Owner	Specifies the owner of the endpoint. Scripting name: Owner
State	Specifies the state of the endpoint at creation. You can choose between: started stopped disabled Scripting name: State
Protocol: Name	Specifies the transport protocol to be used by the endpoint. You can choose between: http tcp Scripting name: Protocol
Protocol: Argument	Allows you to enter arguments for the chosen protocol. Scripting name: ContentType
Language: Name	Specifies the type of content to be sent. You can choose between: soap tsql service_broker database_mirroring Scripting name: Language
Language: Argument	Allows you to enter arguments for the chosen language. Scripting name: LanguageArgument