Solved

Microsoft SQL 2005 and Windows TCPIP changes to segment the network

Posted on 2011-03-22
3
298 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:sedostal
  • 2
3 Comments
 
LVL 13

Accepted Solution

by:
agarwalrahul earned 500 total points
ID: 35195623
0
 

Author Comment

by:sedostal
ID: 35197878
have you tried this procedure, did it work for you?
0
 

Author Closing Comment

by:sedostal
ID: 35202597
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
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question