Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

How many system endpoints are available in SQL Server 2005? Expand / Collapse
Posted Thursday, July 29, 2010 9:47 AM



Group: General Forum Members
Last Login: 2 days ago @ 4:03 PM
Points: 1,889, Visits: 2,556
Dear Lynn

In your query analyser, after executing the below query, are u able to see the result as 6?

select name, endpoint_id from sys.endpoints where endpoint_id < 65536

I think TCP port is ideally termed as HTTP Endpoints and widely used in writing web methods.

Apologies if I am wrong..!


Post #960827
Posted Friday, July 30, 2010 9:21 AM


Group: General Forum Members
Last Login: Wednesday, October 9, 2013 2:07 PM
Points: 407, Visits: 356
I chose 4 as I forgot about DAC. Good question.
Post #961487
Posted Wednesday, August 18, 2010 8:08 AM



Group: General Forum Members
Last Login: Monday, November 23, 2015 1:12 PM
Points: 2,405, Visits: 18,210
To add to the confusion, here is a BOL page that states there is always exactly one system endpoint: sys.endpoints. On the same page, it also states "An endpoint with an ID less then 65536 is a system endpoint", which in my case was 5. I guess it depends on how you interpret the word "system".

Post #971154
Posted Sunday, October 17, 2010 5:28 PM

SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, November 26, 2015 10:18 PM
Points: 8,909, Visits: 10,772
UMG Developer (7/27/2010)
Thanks for the question, though I find it interesting that BOL has conflicting information.

No, there isn't conflicting information in BoL, just careless reading of BoL information. The list of 6 endpoint types includes HTTP endpoints, and it is clearly stated in the paragraph immediately after the list that all HTTP endpoints are user created not system (default) endpoints (and don't show up in SQL Server Configuration Manager); each of the other 5 types has one system endpoint created during instance installation whether or not the relevant protocol is enabled (not all protocols are enabled on installation), and these 5 are the only system endpoints of the instance.

Since I tend to favour web services as a way of getting from client to server in some circumstances and TCP in others the first endpoint types that sprang to mind were HTTP and TCP so I counted two there and then added one each for shared memory, named pipes, VIA and DAC to get six, forgetting that HTTP doesn't count because there is no system http endpoint, and ending up with the wrong answer - no points for me this time, although I not only should but also do know better.

Post #1005945
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse