Named pipes question.

Is it possible to configure named pipes only on one NIC and tcpip on the
other' (SQL 2000 sp3)
PierreNot in SQL 2000. You cannot protocol 'affinitize' NIC's
(Hopefully in the next version)
"Pierre" <Pierre.roman@.qunara.com.nospam> wrote in message
news:%23E0dhpvqDHA.2632@.TK2MSFTNGP09.phx.gbl...
> Is it possible to configure named pipes only on one NIC and tcpip on the
> other' (SQL 2000 sp3)
> Pierre
>|||Thanks
"Dieter Katzenland" <deiter@.rrtc.com> wrote in message
news:uYNs2SwqDHA.2772@.TK2MSFTNGP12.phx.gbl...
> Not in SQL 2000. You cannot protocol 'affinitize' NIC's
> (Hopefully in the next version)
> "Pierre" <Pierre.roman@.qunara.com.nospam> wrote in message
> news:%23E0dhpvqDHA.2632@.TK2MSFTNGP09.phx.gbl...
> > Is it possible to configure named pipes only on one NIC and tcpip on the
> > other' (SQL 2000 sp3)
> >
> > Pierre
> >
> >
>|||Pierre,
Yes, but only with a (software) firewall.
Named pipes use SMB, TCP/IP uses port 1433 (default).
You cannot currently separate the protocols by any binding or SQL setup that I know of.
Regards
AJ
"Pierre" <Pierre.roman@.qunara.com.nospam> wrote in message news:%23E0dhpvqDHA.2632@.TK2MSFTNGP09.phx.gbl...
> Is it possible to configure named pipes only on one NIC and tcpip on the
> other' (SQL 2000 sp3)
> Pierre
>