Oct 7, 2013

End Points in Sql Server

A SQL Server endpoint is the point of entry into SQL Server, or a way to connect to SQL Server instance.

Endpoints in SQL Server are similar to Web Services that expose database access over HTTP.
There are 5 system endpoints that are automatically created and that can’t be dropped (you can only start or stop them), one for each protocol
  • TCP/IP
  • Shared Memory
  • Named Pipe
  • VIA
One endpoint for the dedicated administrator connection (DAC).

Query to list all end points in SQL Server
select * from sys.endpoints

Endpoints which have ID less then 65536 are system endpoints.

In the next article we will see how to Create Endpoint in SQL Server

System End Points can't be dropped, however they can be started or stopped.

To see how to start or stop an endpoint in SQL Server, read related blog post:
How to start or stop an endpoint in SQL Server

    Choose :
  • OR
  • To comment
1 comment:
Write Comments