Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Change IP adresses of clustered SQL 2000


Change IP adresses of clustered SQL 2000

Author
Message
Samo82
Samo82
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 15
Dears,

I need to change all the IPs related to a production DB (4 IPs (NICs , Windows and SQL) )
The database is sql 2000 SP4 and windows is 2003 SP2 . Clustered two nodes.

Have any one ever performed such action ? I need to make sure to perform the change smoothly without issues.

Thank you .
sdelachapelle
sdelachapelle
Valued Member
Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)

Group: General Forum Members
Points: 65 Visits: 1597
Hello,

Glad to see that we are not the only people on earth who still have to maintain a SQL 2000 cluster :-P

I never did this type of change myself but according the MS documentation http://technet.microsoft.com/en-us/library/cc917693.aspx it is possible to add, change or update a TCP/IP address on a Virtual Server.

I would suggest to add the new IPs, validate it works then remove the old one, only possible of course if you do not move to a new network.

Please post your feedback, I am really curious how you are going to proceed.

Best regards.
Samo82
Samo82
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 15
Thank you. Actually its an old installation that's why I still have to handle such cases.

The provided article skipped the procedure to SQL cluster IP change. I think the procedure should be something like the below
1-Change the IPs of the domain controller ( which are the DB nodes)
2-Change the IP of the windows cluster
3-Change the IP of SQL cluster.

Hopefully you or someone else tried this before.

Thanks Again.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search