Additional IP for SQL Cluster

Giganews Newsgroups
Subject: Additional IP for SQL Cluster
Posted by:  Dragon (
Date: Wed, 15 Nov 2006


We have a two node failover SQL 2000 cluster setup. These servers are on a
closed netowrk where they do not have access to internet or anything other
network. I now have a need to be able to connect to the SQL server from
another network. I had added the correct gateway etc and can assign a new IP
in the cluster for outside access. Everything work fine except that SQL will
not listen on this IP. I am assigning the new IP on the same NIC as my
cluster's public IP. Does anyone know who do I go about making SQL  listen
on both IPs?

Thank you.