Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Sourav Mukherjee » How many system endpoints are available in...
Add to briefcase
14 posts, Page 2 of 2
««12

How many system endpoints are available in SQL Server 2005? Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
SQL-DBA-01
Posted Thursday, July 29, 2010 9:47 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 9:12 AM
Points: 738, Visits: 1,125
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..!

Cheers,

Thanks.
Post #960827
zskinne
Posted Friday, July 30, 2010 9:21 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, May 17, 2013 12:49 PM
Points: 406, Visits: 342
I chose 4 as I forgot about DAC. Good question.
Post #961487
Chad Crawford
Posted Wednesday, August 18, 2010 8:08 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 4:17 PM
Points: 2,548, Visits: 17,356
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".

Chad
Post #971154
L' Eomot Inversé
Posted Sunday, October 17, 2010 5:28 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:48 PM
Points: 7,088, Visits: 7,143
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.

Tom
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)
Post #1005945
« Prev Topic | Next Topic »

Add to briefcase
14 posts, Page 2 of 2
««12

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.