Listening IP address

Hi,
I'm running MS SQL 2000 on Windows 2000 adv srv with 2 network adapters on
it .
How can I configure MS SQL to listen from one IP address and don't listen
from another?
Thanks,
LeonidYou can't do this with SQL. You could block the port on the adapter using
IPSEC
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Leonid" <le_le_to@.hotmail.!!!NO-SPAM!!!.com> wrote in message
news:qJGdnZeQApEvx5Xd4p2dnA@.comcast.com...
> Hi,
> I'm running MS SQL 2000 on Windows 2000 adv srv with 2 network adapters on
> it .
> How can I configure MS SQL to listen from one IP address and don't listen
> from another?
> Thanks,
> Leonid
>sql