InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 09:20:15 GMT20http://www.sqlservercentral.com/Forums/Topic959174-2698-1.aspx[quote][b]UMG Developer (7/27/2010)[/b][hr]Thanks for the question, though I find it interesting that BOL has conflicting information.[/quote]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 [i]system[/i] 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.Sun, 17 Oct 2010 17:28:41 GMTL' Eomot Inverséhttp://www.sqlservercentral.com/Forums/Topic959174-2698-1.aspxTo add to the confusion, here is a BOL page that states there is always exactly one system endpoint: [url=http://msdn.microsoft.com/en-us/library/ms189746(v=SQL.90).aspx]sys.endpoints[/url]. 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".ChadWed, 18 Aug 2010 08:08:16 GMT Chad Crawfordhttp://www.sqlservercentral.com/Forums/Topic959174-2698-1.aspxI chose 4 as I forgot about DAC. Good question.Fri, 30 Jul 2010 09:21:45 GMTzskinnehttp://www.sqlservercentral.com/Forums/Topic959174-2698-1.aspxDear LynnIn 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 &lt; 65536I think TCP port is ideally termed as HTTP Endpoints and widely used in writing web methods.Apologies if I am wrong..!Cheers,Thu, 29 Jul 2010 09:47:14 GMTSQL-DBA-01http://www.sqlservercentral.com/Forums/Topic959174-2698-1.aspxI'll disagree and say 6:Shared MemoryNamed PipesTCP/IPVIADACHTTPThu, 29 Jul 2010 09:39:26 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic959174-2698-1.aspxThanks 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 :-)Wed, 28 Jul 2010 02:25:03 GMTkwex07http://www.sqlservercentral.com/Forums/Topic959174-2698-1.aspxThanks for the question, though I find it interesting that BOL has conflicting information.Tue, 27 Jul 2010 22:21:34 GMTUMG Developerhttp://www.sqlservercentral.com/Forums/Topic959174-2698-1.aspxThanks Jason...! Actually, I was configuring a "Database Mirroring" once, so thought to post the question to the Group! :)Tue, 27 Jul 2010 09:09:48 GMTSQL-DBA-01http://www.sqlservercentral.com/Forums/Topic959174-2698-1.aspxNice question. No idea why this stuck in my head without review or research.Tue, 27 Jul 2010 09:07:13 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic959174-2698-1.aspxI love questions that make me do a little reading to brush up on weak areas. Thanks.Tue, 27 Jul 2010 06:36:08 GMTDaniel Bowlinhttp://www.sqlservercentral.com/Forums/Topic959174-2698-1.aspxI had never heard of endpoints, but apparently my BOL reference was better than Michael's :) I did get it correct.[url]http://blogs.msdn.com/b/sql_protocols/archive/2005/10/14/480842.aspx[/url]Thanks for question - learned something new today.CindyTue, 27 Jul 2010 06:25:55 GMTCavyPrincesshttp://www.sqlservercentral.com/Forums/Topic959174-2698-1.aspxApparently trusted the wrong reference on MSDN:[url]http://msdn.microsoft.com/en-us/library/ms191220(SQL.90).aspx[/url]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:Tue, 27 Jul 2010 03:46:25 GMTmichael.kaufmannhttp://www.sqlservercentral.com/Forums/Topic959174-2698-1.aspxThank you for the question. I tossed my 5-sided coin and got the right answer, then read up on endpoints.[url]http://www.simple-talk.com/sql/database-administration/sql-server-endpoints-soup-to-nuts/[/url] gives a good description of endpoints.Tue, 27 Jul 2010 01:52:54 GMTmartin.whittonhttp://www.sqlservercentral.com/Forums/Topic959174-2698-1.aspxComments posted to this topic are about the item [B]<A HREF="/questions/networking/70388/">How many system endpoints are available in SQL Server 2005?</A>[/B]Mon, 26 Jul 2010 22:10:18 GMTSQL-DBA-01