Online Documentation for SQL Manager for SQL server

Endpoints

Communication of SQL Server Database Engine with an application is formatted in a Microsoft communication format called a tabular data stream (TDS) packet. The TDS packet is encapsulated inside a standard communication protocol (such as TCP/IP or Named Pipes) by the Net-Libraries on both the server and the client computers. On the server side the Net-Libraries are part of the Database Engine, whereas on the client side the Net-Libraries are part of the SQL Native Client. To configure Net-Libraries, the server and the SQL Native Client are configured to use a network protocol. The server creates a SQL Server object called a TDS Endpoint for each network protocol.

Endpoint Editor allows you to define endpoint properties. It opens automatically when you create a new endpoint and is available on editing an existing one.

To open an endpoint in Endpoint Editor, double-click it in the DB Explorer tree. Alternatively, you can right-click the endpoint alias and select the Edit Endpoint context menu item.

• Using Navigation bar and Toolbar
• Setting endpoint properties
• Setting protocol options
• Setting payload options
• Viewing DDL definition