Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Changing IP of the cluster

 
   Database Forums (Home) -> Clustering RSS
Next:  TempDB won't shrink  
Author Message
Igor Marchenko

External


Since: Jan 11, 2008
Posts: 13



(Msg. 1) Posted: Fri Jan 18, 2008 9:49 am
Post subject: Changing IP of the cluster
Archived from groups: microsoft>public>sqlserver>clustering (more info?)

Hello!

We will be moving our two cluster running SQL Server 2005 64-bit SP2 on
Windows 2003 to the different datacenter. IP addressed of both nodes will be
changed by DNS names remain the same. I was wondering if anyone had issues
with this. Out thought is that we just need to update IPs in Cluster Manager.

Comments are welcome.
Igor

 >> Stay informed about: Changing IP of the cluster 
Back to top
Login to vote
Geoff N. Hiten

External


Since: Feb 23, 2005
Posts: 443



(Msg. 2) Posted: Fri Jan 18, 2008 1:35 pm
Post subject: Re: Changing IP of the cluster [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Here are the instructions from BOL:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/b685f400-cbfe-4c5d-a070-227a1123dae4.htm

The real key is to only change one network at a time and make sure at least
two networks are enabled for private cluster communication. Always give the
cluster a working private communications path so it can settle cluster-wide
changes.

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


"Igor Marchenko" wrote in message

> Hello!
>
> We will be moving our two cluster running SQL Server 2005 64-bit SP2 on
> Windows 2003 to the different datacenter. IP addressed of both nodes will
> be
> changed by DNS names remain the same. I was wondering if anyone had issues
> with this. Out thought is that we just need to update IPs in Cluster
> Manager.
>
> Comments are welcome.
> Igor
>
>

 >> Stay informed about: Changing IP of the cluster 
Back to top
Login to vote
Igor Marchenko

External


Since: Jan 11, 2008
Posts: 13



(Msg. 3) Posted: Fri Jan 18, 2008 1:35 pm
Post subject: Re: Changing IP of the cluster [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Geoff,

Thanks for your reply! For some reason, I am unable to open this link in
BOL. I am getting 'This programn cannot diplay the webpage...' error. Could
you please send me url to BOL online?

Thanks,
Igor

"Geoff N. Hiten" wrote:

> Here are the instructions from BOL:
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/b685f400-cbfe-4c5d-a070-227a1123dae4.htm
>
> The real key is to only change one network at a time and make sure at least
> two networks are enabled for private cluster communication. Always give the
> cluster a working private communications path so it can settle cluster-wide
> changes.
>
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Igor Marchenko" wrote in message
>
> > Hello!
> >
> > We will be moving our two cluster running SQL Server 2005 64-bit SP2 on
> > Windows 2003 to the different datacenter. IP addressed of both nodes will
> > be
> > changed by DNS names remain the same. I was wondering if anyone had issues
> > with this. Out thought is that we just need to update IPs in Cluster
> > Manager.
> >
> > Comments are welcome.
> > Igor
> >
> >
>
>
 >> Stay informed about: Changing IP of the cluster 
Back to top
Login to vote
Geoff N. Hiten

External


Since: Feb 23, 2005
Posts: 443



(Msg. 4) Posted: Mon Jan 21, 2008 10:52 am
Post subject: Re: Changing IP of the cluster [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Here is the online version of the article.
http://technet.microsoft.com/en-us/library/ms190460.aspx

Best of luck moving the servers.

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


"Igor Marchenko" wrote in message

> Geoff,
>
> Thanks for your reply! For some reason, I am unable to open this link in
> BOL. I am getting 'This programn cannot diplay the webpage...' error.
> Could
> you please send me url to BOL online?
>
> Thanks,
> Igor
>
> "Geoff N. Hiten" wrote:
>
>> Here are the instructions from BOL:
>> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/b685f400-cbfe-4c5d-a070-227a1123dae4.htm
>>
>> The real key is to only change one network at a time and make sure at
>> least
>> two networks are enabled for private cluster communication. Always give
>> the
>> cluster a working private communications path so it can settle
>> cluster-wide
>> changes.
>>
>> --
>> Geoff N. Hiten
>> Senior SQL Infrastructure Consultant
>> Microsoft SQL Server MVP
>>
>>
>> "Igor Marchenko" wrote in
>> message
>>
>> > Hello!
>> >
>> > We will be moving our two cluster running SQL Server 2005 64-bit SP2
>> > on
>> > Windows 2003 to the different datacenter. IP addressed of both nodes
>> > will
>> > be
>> > changed by DNS names remain the same. I was wondering if anyone had
>> > issues
>> > with this. Out thought is that we just need to update IPs in Cluster
>> > Manager.
>> >
>> > Comments are welcome.
>> > Igor
>> >
>> >
>>
>>
 >> Stay informed about: Changing IP of the cluster 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Changing Collation on a Cluster - Hi, I am sure that someone has managed to do this. We have a 64_bit Clustered SQL2005 SP2 build 3175 server that we created as Latin1_General_Bin. We want to change it to the North American default but keep getting errors. The latest was: - SQL Serve...

SQL Server 2005 - Changing Port in Cluster Environment - I have setup an Active Passive Cluster in SQL Server 2005. For security issue we wanted to change the port from default 1433 to 1456. In SQL Server 2000 it was pretty straight forward but it looks complicated in SQL Server 2005. If anyone has done..

Why SQL cluster changing owner after taking offline and br.. - Hi, I have a failover cluster with SQL Server 2000 SP4 installed on it. The SQL Server is on the current active node which is SQLUU. last night, I took the SQL Server offline from cluster administrator, and then immediatelt bring online again...

Database resource won't start after changing cluster subnet - I'm running a SQL Server 2000 SP4 2-node active/acitve cluster on Windows 2003 Server Enterprise Edition SP1. I changed the subnet mask of my public network config, as well as the MCS virtual subnet and two database resource subnets (all are using the..

Changing SQL Service account passowrd on a cluster configu.. - Hi, I have SQL 2005 server (with Named Instance) running on a two node Cluster Configuration (Active/Passive). SQL Instance, SQL Server Agent, SQL Server Browser services are running under a service account (domain account). Similarly Cluster service...
   Database Forums (Home) -> Clustering All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]