<div>
yes, the new IP's are all in the same subnet, but different from the current subnet. &nbsp;We don't use heartbeat interfaces on any of our SQL clusters (don't ask).<br />
<br />
Going forward we will have a few SQL 2005 and maybe one SQL 2000 cluster. &nbsp;Any gotcha's with those?
</div>


yes, the new IP's are all in the same subnet, but different from the current subnet.  We don't use heartbeat interfaces on any of our SQL clusters (don't ask).

Going forward we will have a few SQL 2005 and maybe one SQL 2000 cluster.  Any gotcha's with those?

<div>
It all looks good, just change the IPs and make sure that DNS gets updated.<br />
I'd recommend ipconfig /flushdns on each node after change for safety.
</div>


It all looks good, just change the IPs and make sure that DNS gets updated.
I'd recommend ipconfig /flushdns on each node after change for safety.

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
We are in the middle of a large re-IP project for all of our servers, which include several 2008R2 SQL two node clusters. &nbsp;I'm wondering if there is a best practice for changing the IP addresses?<br />
<br />
Our thoughts so far with changing the IP's in order:<br />
<br />
passive node<br />
active node<br />
Windows cluster IP<br />
SQL IP<br />
DTC<br />
<br />
Any recommendations?
</div>
</div>


Hi

We are in the middle of a large re-IP project for all of our servers, which include several 2008R2 SQL two node clusters.  I'm wondering if there is a best practice for changing the IP addresses?

Our thoughts so far with changing the IP's in order:

passive node
active node
Windows cluster IP
SQL IP
DTC

Any recommendations?

Changing IP addresses of 2008R2 SQL Cluster

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.