What is Benefit of SQLSERVER END points

A SQL Server endpoint is the point of entry into SQL Server. It is implemented as a database object that defines the ways and means  in which SQL Server may communicate over the network. SQL Server routes all interactions with the network via endpoints and each endpoint supports a specific type of communication.It works in the same way as a firewall in order to limit the traffic that what your administrator is expected.The advantage of a user-defined endpoint is that traffic must be authorised before it even reaches SQL Server.

An endpoint has a transport(payload), which will either be HTTP or TCP. A SQL Server login should have granted 'CONNECT' permission to use an endpoint.

Types of endpoints - TSQL, DATABASE_MIRRORING, SERVICE_BROKER

Use cases:

1. Database Mirroring
2. Service Broker Scenario
3. DBA need to monitor a remote production system.


Refer http://msdn.microsoft.com/en-us/library/ms181591.aspx for creation of endpoints.