Monday, October 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. 

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

To create endpoint, refer related blog post:
Create Endpoint in SQL Server


Post a Comment