?? Turning Off TCP/IP Client Has No Effect ??

Hi Everyone,

I was doing some testing with client configuration and I'm seeing
something I don't understand. Let me explain the setup.

My setup involves a single machine running "SQL Server Express 2005".
As you probably know, SSE includes the "SQL Server Native Client". I
run the "SQL Server Configuration Manager" and under the "SQL Native
Client Configuration" | "Client Protocols" node, I disable TCP/IP. My
understanding is that this should prevent clients on this machine from
using TCP/IP to connect to any SQL Server instance. Does this sound
right so far?

Well, when I run SQLCMD (specifying "tcp:" as the protocol) I am still
able to connect to the instance on the local machine.

In other words, I have TCP/IP disabled as a client protocol, yet I am
still able to successfully connect to an instance using SQLCMD with a
command line like this:

SQLCMD -s tcp:.\TEST_01 -d AdventureWorks

Now, it's my understanding that SQLCMD relies upon the "SQL Server
Native Client". And since I've (supposedly) configured the "SQL Server
Native Client" *NOT* to allow TCP/IP connections, the above SQLCMD
connection should not work, yet it does.

What am I missing here?

--
Alan


.

Relevant Pages

  • SMS 2003 Connecting Offsite Clients...
    ... I have a client who wants to be able to setup a standard Primary site ... is there some configuration that would satisfy the above requirements? ... And B. Would having site to site vpns at the remote sites to the main ...
    (microsoft.public.sms.admin)
  • Re: Help for SQL server setup??
    ... It is a accounting system I install on this server, but it needs ODBC connection to client PC. ... So I need help for setup SQL server, ... The problem is how to set up SQL server for client PC ocnnect?? ...
    (microsoft.public.windows.server.sbs)
  • Re: Best way to populate webpages from multiple tables
    ... tables within hash tables, custom classes etc. ... > Set a session expiring cookie at the client that stores the Customer ID. ... > send it to the client, instead store it in your session mgmt sql server - ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Best way to populate webpages from multiple tables
    ... tables within hash tables, custom classes etc. ... > Set a session expiring cookie at the client that stores the Customer ID. ... > send it to the client, instead store it in your session mgmt sql server - ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL and Bandwidth use
    ... In addition to the other responses, take a look at the memory and CPU usage ... in Great Plains Client software. ... > near 100Mb/sec bandwidth). ... Client PC is on same segment as SQL server (not passing through ...
    (microsoft.public.sqlserver.server)