RE: Named Pipes

From: Linchi Shea (linchi_shea_at_NOSPAMml.com)
Date: 01/08/04 

Date: Thu, 8 Jan 2004 09:48:35 -0800

Kevin;

> If they attempt to connect via sockets and fail,
> the client transparently will attempt making a
> Named Pipe connection. This is of

What are the exactly conditions for this 'transparent
attempt of making a Named Pipe connection' to occur? What
are scenarios in which this transparent attempt will not
be 'attempted'? I'm thinking about the situation when you
use a server alias or prefix your server name with 'tcp:'.

Linchi

>-----Original Message-----
>There's really no reason to remove it. It gives you an
alternate IPC to
>connect to the server with if for example we're unable to
bind to the TCP
>port. MDAC 2.6 clients then also have alternate means to
connect to your
>server. If they attempt to connect via sockets and fail,
the client
>transparently will attempt making a Named Pipe
connection. This is of
>great benefit to users who are no interested in how SQL
connects, just that
>it connects.
>
>If your SQL Server is behind a firewall, the firewall
should be configured
>to only allow the tcp traffic for SQL. There's no
additional overhead on
>the server to listen on both netlibs.
>
>If you're using a SQL Cluster then you won't be able to
remove Named Pipes
>after applying sp3.
>
>831127 Named Pipes Support Cannot Be Removed on a Virtual
Server That Is
>http://support.microsoft.com/?id=831127
>
>
>Thanks,
>
>Kevin McDonnell
>Microsoft Corporation
>
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>
>
>.
>

Relevant Pages

  • RE: Resolving an IP address from a SQL Server Instance Name
    ... An error has occurred while establishing a connection to the server. ... under the default settings SQL Server does not allow remote connections. ... you enabled Named Pipe. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Are write() calls guaranteed atomic?
    ... >> writing the data have no knowledge of the FIFO, ... > If you cannot modify the clients, try changing your server to create a ... > Unix domain socket instead of a named pipe (the clients shouldn't see ...
    (freebsd-hackers)
  • Re: Background Processing in an MFC application
    ... So what is the relationship of the client and the server? ... I can believe the thread that is communicating with the named pipe launches Adobe ... Reader, but I can't believe that the named pipe calls anything. ...
    (microsoft.public.vc.mfc)
  • SQL Server on SBS 2003
    ... 2 instances of sql server (SBSMONITORING and SHAREPOINT) ... All two listening as named pipe and TCP on port 1433. ...
    (microsoft.public.sqlserver.setup)
  • Re: Question About Isaserver
    ... > plz help me about how I can Transparent microsoft isa ... I'm not sure I understand what you mean by transparent the proxy. ... two ways to use ISA server to configure the settings including using the IE ...
    (microsoft.public.win2000.security)
Quantcast