Re: ?? Turning Off TCP/IP Client Has No Effect ??
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Mon, 10 Apr 2006 22:31:27 +0000 (UTC)
Alan Foxmore (AFoxmore@xxxxxxxxx) writes:
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?
Not really. Client protocols only controls which protocol that client
programs use by default. I gueds you override that when you specify
tcp: on the command line. (I have not verified this.)
If you want to protect the server, you should confgure the server
protocols so that TCP is disabled.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- ?? Turning Off TCP/IP Client Has No Effect ??
- From: Alan Foxmore
- ?? Turning Off TCP/IP Client Has No Effect ??
- Prev by Date: Re: "Some trace events have not been reported to SQL Profiler" - Erro
- Next by Date: Re: SQL Server 2005 Generate Scripts does not script role members any
- Previous by thread: ?? Turning Off TCP/IP Client Has No Effect ??
- Next by thread: Re: Queries spanning multiple connections
- Index(es):
Relevant Pages
|
