Sunday, March 25, 2012

Additional IP for SQL Cluster

Hi,
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.
Hi
Have you made the IP address available as a resource to SQL Server?
John
"Dragon" wrote:

> Hi,
> 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.
>
>
|||Open the cluster administrator tool and add an IP Address resource to the
group that SQL has been installed in. You will need to have a different IP
bound to the NIC for this to work, but of course on that same subnet.
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Dragon" <baadil_nospam@.hotmail.com> wrote in message
news:OHT8S4NCHHA.4680@.TK2MSFTNGP04.phx.gbl...
> Hi,
> 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.
>
|||I read the other two responses, and although they were posted in the SS
cluster forum, they are clearly OS answers. They will not work.
Every Operation DBA knows that you cannot manage SQL Server 2000 Cluster IP
addresses through the Cluster Administrator APIs.
You must rerun the SQL Server 2000 Setup utility, Virtual Server, Advanced
Options, Manager Cluster Resources, and add the additional IP resources from
the Network Dialog.
The only other alternative would be to hack the registry (HKLM\Cluster and
HKLM\SOFTWARE\Microsoft, either Microsoft SQL
Server\MSSQL$InstanceName\MSSQLServer or MSSQLServer\MSSQLServer cluster
keys and resources).
Sincerely,
Anthony Thomas

"Dragon" <baadil_nospam@.hotmail.com> wrote in message
news:OHT8S4NCHHA.4680@.TK2MSFTNGP04.phx.gbl...
> Hi,
> 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.
>
sql

No comments:

Post a Comment