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: installing SQL 2008 x64 on Vista Enterprise x64-Firewall warnings
    ... I can't see the warning at the moment but my recollection is that is just warns you that the firewall is on and you might have to configure it. ... Since setup doesn't know what you want to do with SQL Server it can't tell if you have configured it correctly. ... How can I get rid of this warning and continue with my installation? ... 135 TCP - SQL Server Integration Services ...
    (microsoft.public.sqlserver.setup)
  • installing SQL 2008 x64 on Vista Enterprise x64-Firewall warnings
    ... I am installing default instance of SQL Server 2008 x64 on Windows Vista ... Firewall" generated a warning. ... How can I get rid of this warning and continue with my installation? ... 135 TCP - SQL Server Integration Services ...
    (microsoft.public.sqlserver.setup)
  • 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)