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»»

Protocols Expand / Collapse
Author
Message
Posted Thursday, December 27, 2007 8:39 PM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
Comments posted to this topic are about the item Protocols
Post #436879
Posted Friday, December 28, 2007 4:00 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, October 21, 2013 7:25 AM
Points: 77, Visits: 253
I think that it would be impossable to get this question correct ( unless you chose the incorrect series)as it does not give you the option to select Local named pipes as opposed to (generic) named pipes which includes both local and network connection type

Of course named pipes is disabled for network connections


Kevin Brennan M.Sc, MCITP, MCDBA, MCSE, MCTS,MCP+I
Post #436975
Posted Friday, December 28, 2007 5:29 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 6:09 AM
Points: 2,370, Visits: 1,263
According to SQL Server Books online, named pipes are enabled for Local connections. This should have been specified in the list of protocol types.
Post #437004
Posted Friday, December 28, 2007 7:15 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, August 16, 2011 5:47 AM
Points: 68, Visits: 36
This isnt a fair question, named pipes is enabled locally, but tecnically enabled, if you look at the develper center, it in facts states enabled:

http://msdn2.microsoft.com/en-us/library/ms190198.aspx
Post #437036
Posted Friday, December 28, 2007 8:29 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 11:58 AM
Points: 3,924, Visits: 1,588
Shared memory - TSQL LocalMachine
Named Pipes - TSQL Named Pipes
TCP/IP - TSQL Default TCP
VIA - TSQL Default VIA
DAC - Dedicated Admin Connection



SQL DBA.
Post #437080
Posted Friday, December 28, 2007 8:35 AM


SSC-Addicted

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

Group: General Forum Members
Last Login: Monday, January 20, 2014 3:38 PM
Points: 473, Visits: 8,736
I gotta say that I agree with everyone else on this one; the question was a bit of a tricky question in that "Named Pipes" is technically enabled, even if it is only for local connections.

It would've been nice to have an option (or two, to throw us off) with selecting a protocol as being enabled with local connections only.

What a way to end the year!....

Happy New Years all!

James


~ Without obstacles, you cannot progress ~
http://sqln.blogspot.com/
Post #437084
Posted Friday, December 28, 2007 2:41 PM
SSC-Addicted

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

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 1:05 AM
Points: 488, Visits: 400
Once again, the question poser asks one question ("which protocols are enabled") and gives a wrong answer, by using a definitive statement that answers a DIFFERENT issue (about "Network Protocols"). Network? When did that word slip into the question? Who limited things to NETWORK protocols?
Obviously(?) named pipes are only local with the default installation, but that IS a protocol. Okay, it's not a NETWORK protocol, but that wasn't the question, was it?
It's bad enough getting a wrong answer when I've got it wrong; it's downright exasperating when the 'right' answer is demonstrably wrong!
Doesn't anybody check that the question poser knows what they're talking about?
Post #437244
Posted Sunday, December 30, 2007 10:16 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:17 AM
Points: 5,471, Visits: 23,519
Agree with the fact that the question is not properly phrased for what it considered the correct answer.

NOW WILL SOME ONE BE NICE AND TAKE THE FLAG OFF OUR RECORDS INDICATING THAT WE DID NOT ANSWER THE QUESTION CORRCTLY


If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #437386
Posted Sunday, December 30, 2007 11:11 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 11:24 AM
Points: 32,781, Visits: 14,942
All answers have been marked correct.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #437389
Posted Sunday, December 30, 2007 1:57 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:17 AM
Points: 5,471, Visits: 23,519
Steve Jones - Editor (12/30/2007)
All answers have been marked correct.


More than I expected, and more than we deserve, no matter let me say thank you.

Now what are you doing working on a Sunday?


If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #437402
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse