Getting SQL Server 2000 to listen only to the loopback device

Is it possible to get SQL Server 2000 to listen only to connections on
the Microsoft loopback device?
I am running a proprietary analysis package on top of SQL Server that
requires that a TCP/IP connection. I will never connect to SQL Server
remotely, so I would like to avoid having SQL Server listen for
connections on my network adapter.
I am running SQL Server Personal Edition on Windows 200 SP4.
Any thoughts on how to set this up?
Thanks,
Chris Green
joeionnojitsu AT comcast.netThe MS loopback device is network address 127.0.0.1 ' Is that what
you are referring to'
Have you looked at the following articles?
http://support.microsoft.com/?id=287932
http://support.microsoft.com/default.aspx?kbid=814130
Since the entire point behind a server is to provide for several
clients, your goal doesn't seem feasible unless you have a firewall
that blocks everything destined for the server, and not coming from
the local host.
Lou Arnold
On Thu, 24 Jun 2004 06:13:27 GMT, c green
<joeionnojitsu@.NOSPAM.comcast.net> wrote:
>Is it possible to get SQL Server 2000 to listen only to connections on
>the Microsoft loopback device?
>I am running a proprietary analysis package on top of SQL Server that
>requires that a TCP/IP connection. I will never connect to SQL Server
>remotely, so I would like to avoid having SQL Server listen for
>connections on my network adapter.
>I am running SQL Server Personal Edition on Windows 200 SP4.
>Any thoughts on how to set this up?
>Thanks,
>Chris Green
>joeionnojitsu AT comcast.net