Named Pipes/TCPIP? 1

[Will192]

Win 2000 Advanced Server
SQL 2000 Enterprise

My above server is running Named Pipes and TCPIP. Some machines connect with Named Pipes and some connect as TCPIP. The Named Pipes run much slower than TCPIP.

Here's my question. If I remove the Named Pipes protocol from the list, will all users connect through TCPIP?

I don't know if I remember is correctly or not, but isn't Named Pipes a protocol that was used for Win95 users connecting to SQL Server back in the 6.5 days?

 

[vongrunt]

> If I remove the Named Pipes protocol from the list, will all users connect through TCPIP?

If client machines currently using named pipes are also properly configured for TCP/IP, very likely.

Yup, npipes are slower - more overhead goes on ping-pong protocol - but are apparently safe against client failure.

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)