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

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...

quote:

---

> 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
>

---

|||By default you can't do this. You could put the SQL Server behind an ISA
server (firewall) and only publish the IP that you need.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

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...

quote:

---

> 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
>

---