Choose client net lib?

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"Becker" <ben@.benbecker.net> wrote in message
news:%23T0zraKdEHA.228@.TK2MSFTNGP11.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?
If you install the SQL Server client network utility tool, you can verify
which libraries are installed and in which order that are used.
Steve

Check TCP port

I have establlished a MSDE server.
I know how to check the TCP port at the server.
But, I also want to know if it is possible to check the
TCP port from other workstation?
Please advise.
Thanks.
hi,
A4apple wrote:
> I have establlished a MSDE server.
> I know how to check the TCP port at the server.
> But, I also want to know if it is possible to check the
> TCP port from other workstation?
> Please advise.
> Thanks.
in order to check connectivity, you can perhaps ping the server, or telnet
it, like
c:\..\>telnet servername port_num ;
if the screen becomes black you are connected to the SQL Server instance
(type quit to exit)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply