Re: Moving SQL2005 fail-over cluster between domain

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Geoff N. Hiten" <SQLCraftsman@xxxxxxxxx>
Date: Wed, 16 May 2007 09:49:56 -0400

Right now, the only supported way to move a SQL 2005 cluster is by uninstalling and reinstalling.

This is due to the use of domain groups for security management. The installer is the only tool that sets the permissions correctly.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

"Pierluigi" <Pierluigi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:D2AF4817-D33C-423E-BD5F-E009AD591083@xxxxxxxxxxxxxxxx

Hi everybody,
I'm looking for documentation about moving a fail-over cluster of SQL2005
between different IP network and between difefrent Windows domain.
Some advice ?
Thanks in advance.
Pierluigi

Prev by Date: Re: sp_configure (RECONFIGURE)
Next by Date: Re: SQL DB without any stored procedures?!
Previous by thread: sp_configure (RECONFIGURE)
Next by thread: Re: Applying SP on SQL Cluster (active/passive) after new nodes Added
Index(es):
- Date
- Thread

Relevant Pages

Re: Issues creating a new failover cluster on the same server
... G:\Microsoft SQL Server\MSSQL.1 ... CHNSQL04 Cluster Group ... Drives: H and F ... Group, the MS DTC Group, and each of the SQL Server Instance Groups running ...
(microsoft.public.sqlserver.clustering)
Re: Clustering Newbie - SAN Advice
... Senior SQL Infrastructure Consultant ... SAN/Smart array or through a fibre channel switch. ... The SAN or Smart array will dictate what internal connection the disks ... single-instance cluster. ...
(microsoft.public.sqlserver.clustering)
Re: Clustering Question
... You could make a test environnement through Virtual Machine to get a picture on Cluster. ... I have worked with Windows 2003 Small Business Server, Exchange Server 2003 and 2000 SQL server but not in a clustered environment. ... > you cannot install Cluster on a Small Business Edition, ...
(microsoft.public.windows.server.clustering)
Re: SQL server 2005 SP2 failing on cluster
... We have been told for a long time that MSDTC is optional on a cluster but is all but required in the real world. ... I'm having problem to update my SQL cluster with SQL server 2005 SP2. ... Package Platform: x86 ... see Help and Support Center at ...
(microsoft.public.sqlserver.clustering)
Re: Cluster group and group 0
... If you take a node offline, all resource groups hosted on it will fail over. ... As for your SQL 2005 cluster, if the node being upgraded goes offline during ... SQL Virtual Server name to connect to the SQL instance. ...
(microsoft.public.sqlserver.clustering)