Gurus,

Running SQL Server 2005 SP2 on a cluster (two nodes, SQL instance running on
each, active/active design). Our network team recently forced us to re-IP
everything because they changed out the routing switches (don't ask). Now,
I was gone for a week when my junior Windows admin re-IP'd the cluster nodes
themselves but did NOT re-IP any IP address resources within the Cluster
interface itself so I came back from my vacation to both SQL instances down.
I re-IP'd the Cluster Group quorum resource successfully (note that the
Heartbeat network for this cluster was not changed). However, both SQL
instances do NOT come up within Cluster Administrator although I can start
them (both SQL Server instances) OUTSIDE of Cluster Administrator. The
event logs indicate SQL having an issue contacting network resources. So I
followed up by changing the IP of these resources in DNS as well but still
no dice. So I went into SQL Configuration management and noticed that the
IP addresses in there still reflect the old addresses. Manually changing
the IPs to the new addresses followed by a restart of each node did not
change anything - the old IP addresses were still there, not the new ones.
So I guess one takeaway here is that one does not change IP addresses within
the SQL Configuration Management snap-in? Anyone seen this problem before?

--
Spin

When you changed the IP Address of the SQL instance(s) did you follow the
following steps:

http://msdn.microsoft.com/en-us/libr...0(SQL.90).aspx

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Spin" <Spin (AT) invalid (DOT) com> wrote

"Geoff N. Hiten" <SQLCraftsman (AT) gmail (DOT) com> wrote

Yes, I did follow those steps. My question now centers on the SQL
Configuration management utility where I noticed that the IP addresses still
reflect the old addresses. Manually changing the IPs to the new addresses
followed by a restart of each node did not change anything - the old IP
addresses were still there, not the new ones. So I guess one takeaway here
is that one does not change IP addresses within the SQL Configuration
Management snap-in?

Please make sure that you have followed the below given steps.

• Start Cluster Administrator.
• Select the resource group with the SQL Server resources.
• Take the IP address resource that you want to change offline. This will
also take all SQL
Server Services resources dependent upon it offline as well.
• Select the IP address resource, right-click, and select Properties;
alternatively, double-click The resource Select the Parameters tab
• Change the IP address. Click Apply. Click OK.
• Bring the resources online.
• Ping the new IP address from all nodes as well as from outside the cluster
to make sure the Change has been successful.

Manpreet Singh
http://crazysql.wordpress.com/
MCITP -- SQL Server 2005
MCTS – SQL Server 2005
MCTS – MS SharePoint Server 2007


"Spin" wrote:

I would check the DNS server and see what are the IP's showing under the
Network Name.

Regards,

Pluto

"Spin" wrote: