How choose net lib on client side?

I have SQL Server 7 and it has in the network config utility TCP, Named
Pipes and Multiprotocol. I want to use TCP on my clients, the only problem
is I don't know how to set them up to use this as opposed to named pipes. I
do not want to authenticate at the OS level so I'm trying to get it to use
plain old TCP. By default, all of them appear to be using named pipes. Is
there some way I can confirm or change this theory?
Thanks,
BenYou can manage this using the Client Network Utillity on the client machine.
From the server, you can tell what netlib a client is connecting on by
looking at the net_library column in master..sysprocesses.
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Becker" <ben@.benbecker.net> wrote in message
news:OAtKhaKdEHA.3988@.tk2msftngp13.phx.gbl...
> I have SQL Server 7 and it has in the network config utility TCP, Named
> Pipes and Multiprotocol. I want to use TCP on my clients, the only
problem
> is I don't know how to set them up to use this as opposed to named pipes.
I
> do not want to authenticate at the OS level so I'm trying to get it to use
> plain old TCP. By default, all of them appear to be using named pipes.
Is
> there some way I can confirm or change this theory?
> Thanks,
> Ben
>|||Interesting, so if I don't have the sql client loaded on a machine, what net
library will it use by default? E.g. I have a fresh install of win 2k with
an app that connects to SQL Server, I haven't loaded a client on it but the
app works just fine and it is using named pipes. I want it to use tcp/ip,
do i have to load the client to specify something different?
Thanks,
Ben
"Brian Moran" <brian@.solidqualitylearning.com> wrote in message
news:eD3OdfKdEHA.3864@.TK2MSFTNGP10.phx.gbl...
> You can manage this using the Client Network Utillity on the client
machine.
> From the server, you can tell what netlib a client is connecting on by
> looking at the net_library column in master..sysprocesses.
> --
> Brian Moran
> Principal Mentor
> Solid Quality Learning
> SQL Server MVP
> http://www.solidqualitylearning.com
>
> "Becker" <ben@.benbecker.net> wrote in message
> news:OAtKhaKdEHA.3988@.tk2msftngp13.phx.gbl...
> > I have SQL Server 7 and it has in the network config utility TCP, Named
> > Pipes and Multiprotocol. I want to use TCP on my clients, the only
> problem
> > is I don't know how to set them up to use this as opposed to named
pipes.
> I
> > do not want to authenticate at the OS level so I'm trying to get it to
use
> > plain old TCP. By default, all of them appear to be using named pipes.
> Is
> > there some way I can confirm or change this theory?
> >
> > Thanks,
> > Ben
> >
> >
>