Allow SQL Only to be used on IP Address 127.0.0.1

Hello,
I have a webserver with SQL and only want it accessable via the 127.0.0.1 IP
address. How do I do this.
Thanks,
Jack
You could use a firewall:
http://www.kerio.com/kpf_home.html
blocking all connections incoming from addresses different from 127.0.0.1
Henri
"jack" <jack@.mrolinux.com> a crit dans le message de
news:%2379%23H%23ZUEHA.644@.tk2msftngp13.phx.gbl...
> Hello,
> I have a webserver with SQL and only want it accessable via the 127.0.0.1
IP
> address. How do I do this.
> Thanks,
> Jack
>
>
|||"Henri" <hmfireball@.hotmail.com> wrote in message
news:OtdQ$daUEHA.3016@.tk2msftngp13.phx.gbl...
> You could use a firewall:
> http://www.kerio.com/kpf_home.html
> blocking all connections incoming from addresses different from 127.0.0.1
> Henri
You don't need a third party product to do this.
Just go to network connections, and the properties of the ip interface and
set up ip filtering on that ip address.
David
|||Open the SQL Server Network Utility on the webserver
(Start>Run>svrnetcn.exe) , highlight the enabled protocols and click the
disable button. Now the server will only accept local connections. You need
to specify the server as servername or (local) or . rather than the IP
address but the effect is that only local connections are allowed.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"jack" <jack@.mrolinux.com> wrote in message
news:%2379%23H%23ZUEHA.644@.tk2msftngp13.phx.gbl...
> Hello,
> I have a webserver with SQL and only want it accessable via the 127.0.0.1
IP
> address. How do I do this.
> Thanks,
> Jack
>