<div>
have you tried this procedure, did it work for you?
</div>


have you tried this procedure, did it work for you?

<div>
We tested the second method using part of what was provided with some additional percautions. the first one from Microsoft didn't address the DTC IP changes
</div>


We tested the second method using part of what was provided with some additional percautions. the first one from Microsoft didn't address the DTC IP changes

<div>
<div class="content wysiwyg-content">
We currently have a windows server 2003 R2 running Microsoft SQL 2003 (service pack 1) 2 node cluster. This cluster is a active/passive cluster failing the instances from both directions. We have been asked by our network folks to change the the IP addresses of both nodes so we can move the cluster behind a firewall. This change would involve changes to the windows cluster, MSDTC and SQL server cluster IP addresses. Does anyone have any documented procedures or know of any procedures that would allow us to make IP changes safely without destroying and rebuilding the cluster.
</div>
</div>


We currently have a windows server 2003 R2 running Microsoft SQL 2003 (service pack 1) 2 node cluster. This cluster is a active/passive cluster failing the instances from both directions. We have been asked by our network folks to change the the IP addresses of both nodes so we can move the cluster behind a firewall. This change would involve changes to the windows cluster, MSDTC and SQL server cluster IP addresses. Does anyone have any documented procedures or know of any procedures that would allow us to make IP changes safely without destroying and rebuilding the cluster.

Microsoft SQL 2005 and Windows TCPIP changes to segment the network

Microsoft SQL Server 2005 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. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Transmission Control Protocol/Internet Protocol (TCP/IP) is the set of networking protocols that define end-to-end connectivity specifying how data should be packeted, addressed, transmitted, routed and received at the destination. This functionality is organized into four abstraction layers which are used to sort all related protocols according to the scope of networking involved.