How many system endpoints are available in SQL Server 2005?

Question

How many system endpoints are available in SQL Server 2005?

SQL_Hunt

SSC-Dedicated

Points: 33518
More actions
July 26, 2010 at 10:10 pm

#387433

Comments posted to this topic are about the item How many system endpoints are available in SQL Server 2005?
Thanks.

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

Louisa Whitton SSCrazy Points: 2577 More actions · Answer 1

Thank you for the question. I tossed my 5-sided coin and got the right answer, then read up on endpoints.

http://www.simple-talk.com/sql/database-administration/sql-server-endpoints-soup-to-nuts/ gives a good description of endpoints.

michael.kaufmann SSCrazy Points: 2816 More actions · Answer 2

Apparently trusted the wrong reference on MSDN:

http://msdn.microsoft.com/en-us/library/ms191220(SQL.90).aspx

as this gives a list of 6 automatically created endpoints...

Thanks for the question and for teaching me to doubt any of the Microsoft online resources any time. :Whistling:

CavyPrincess Hall of Fame Points: 3336 More actions · Answer 3

I had never heard of endpoints, but apparently my BOL reference was better than Michael's 🙂 I did get it correct.

http://blogs.msdn.com/b/sql_protocols/archive/2005/10/14/480842.aspx

Thanks for question - learned something new today.

Cindy

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 4

I love questions that make me do a little reading to brush up on weak areas. Thanks.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

Nice question. No idea why this stuck in my head without review or research.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 6

Thanks Jason...! Actually, I was configuring a "Database Mirroring" once, so thought to post the question to the Group! 🙂

Thanks.

UMG Developer SSChampion Points: 13482 More actions · Answer 7

Thanks for the question, though I find it interesting that BOL has conflicting information.

kwex07 SSC Rookie Points: 29 More actions · Answer 8

Thanks for the question ... I read up a little about endpoints from Microsoft's site and came across only the Dedicated Admin Endpoint that is created automatically. I selected 1 as the answer, and you can bet I was wrong!

I should have read till the end of the article before answering the question 🙂

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 9

I'll disagree and say 6:

Shared Memory

Named Pipes

TCP/IP

VIA

DAC

HTTP

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 10

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.

zskinne SSChasing Mays Points: 646 More actions · Answer 11

zskinne

SSChasing Mays

Points: 646

July 30, 2010 at 9:21 am

#1200429

I chose 4 as I forgot about DAC. Good question.

Chad Crawford SSChampion Points: 11610 More actions · Answer 12

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

TomThomson SSC Guru Points: 104773 More actions · Answer 13

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