Re: Choose client net lib?

From: Steve Thompson (stevethompson_at_nomail.please)
Date: 07/28/04


Date: Wed, 28 Jul 2004 14:47:10 -0400


"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



Relevant Pages

  • Re: Problems with Exporting to Excel
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > 4) Send .xls via mail ... I have 12 different pipes from the one ... > sources and multiple sql tasks to run 1 stored proc. ...
    (microsoft.public.sqlserver.dts)
  • Problems with Exporting to Excel
    ... My problem lies in the export from SQL Server to Excel. ... Send .xls via mail ... Sometimes the pipes fail giving error that the document is in use ...
    (microsoft.public.sqlserver.dts)
  • Re: Pipe - Conecpt
    ... Pipes can be opened in two modes. ... UDP, except that it's reliable (delivery and order of messages are ... Just like HTTP is an application-level protocol on top of TCP transport, ...
    (microsoft.public.vc.language)
  • Re: SQL Server 2000 SP4 client connection problem
    ... If you can connect locally using TCP, the SQL Server must be listening on TCP properly. ... And if you see the connection attempts in the log, then TCP/IP must be passing something to SQL Server. ...
    (microsoft.public.sqlserver.connect)
  • RE: Cannot connect to MSDE on a W2003 server
    ... Did you apply the SP3 version of MSDE? ... If not TCP will be disabled on ... Do both remote and local connections fail for each protocol? ... Click the desired instance of Microsoft SQL Server 2000 Desktop Engine ...
    (microsoft.public.sqlserver.connect)