Move SQLserver to use another IP

Hi All,
I need to get the SQLserver (2000) on my Win2K machine to use another IP
than the one it is currently using.
I don't seem to be able to find out how to do it. Any leads/suggestions?
Thank you very much in advance.
Sincerely,
SSQL Server should bind to any IP address that is configured on any NIC
installed in the machine.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||My problem is the following:
I need to run SQLserver 2000 on port 80 on the same machine as I run IIS5 on
port 80.
I want to achieve this by disabling connection pooling and using one IP for
IIS and the other for SQLserver.
But the SQLserver seems to bind to the IP that I am using for my IIS
service. How can I make it only bind the the other IP address?
Thank you very much for any ideas.
Sincerely,
S
"Rand Boyd [MS]" <rboyd@.onlinemicrosoft.com> wrote in message
news:AJqjHKU2DHA.3532@.cpmsftngxa07.phx.gbl...

quote:

---

> SQL Server should bind to any IP address that is configured on any NIC
> installed in the machine.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>

---

|||Susan,
Short answer is you can't. SQL Server has no facility to limit binding to
certain nics.
Long answer is - why would you want SQL Server to listen on port 80? If it'
s
because this gets around a firewall issue, then don't even consider it -
opening SQL Server directly to the internet is a bad idea in almost all
circumstances.

quote:

---

> My problem is the following:
> I need to run SQLserver 2000 on port 80 on the same machine as I run IIS5
on
> port 80.
> I want to achieve this by disabling connection pooling and using one IP fo
r
> IIS and the other for SQLserver.
> But the SQLserver seems to bind to the IP that I am using for my IIS
> service. How can I make it only bind the the other IP address?
> Thank you very much for any ideas.
> Sincerely,
> S
> "Rand Boyd [MS]" <rboyd@.onlinemicrosoft.com> wrote in message
> news:AJqjHKU2DHA.3532@.cpmsftngxa07.phx.gbl...
>

---

Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvfor...p?SRV=MSDevApps
(faqxxx.zip in lib 7)
or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq