We have a current 2-node Windows 2000 Advanced Server cluster running SQL 2K
SP3. We are needing to physically replace the machines in the cluster
(hardware upgrade). The new machines have Windows 2003 Advanced Server
installed.

I figured the easiest way to do this is to remove a node from the cluster
and then add one of the new machines (windows 2003) to the cluster. Then do
the same to the other node. It appears from various KB articles that a
mixed OS environment of 2K & 2K3 are supported (KB313037). Is this correct?

Is there any documentation already out there that covers doing this?

Anyone already attempted and run in to problems? Any advice?

Thanks.
Fred Zelhart

Yes it is supported. Follow the " Windows Server 2003 documentation Help" on upgrading cluster steps.

Articles on 2003 Server clustering:
http://www.microsoft.com/windowsserv...g/default.mspx

http://www.microsoft.com/technet/treeview/default.asp?
url=/technet/prodtechnol/windowsserver2003/technologies/clustering/default.asp

810220 Support WebCast: Windows Server 2003 Clustering: New Features
http://support.microsoft.com/?id=810220

Configuration information:

258750 Recommended Private "Heartbeat" Configuration on a Cluster Server
http://support.microsoft.com/?id=258750

278007 Available Features in Windows Server 2003 Clusters
http://support.microsoft.com/?id=278007

301600 How to Configure Microsoft Distributed Transaction Coordinator on a
http://support.microsoft.com/?id=301600

171791 Creating Dependencies in Microsoft Cluster Server
http://support.microsoft.com/?id=171791



..The only known issues are:
SQL Server does not support the installation or use of SQL Server Failover Clustering on Microsoft Windows Server
2003 server clusters where the Windows Server 2003 server clusters have Terminal Server installed on the cluster.

Thank you
Hina Masud
Microsoft

Disclaimer:
This posting is provided AS IS with no warranties, and confers no rights.
Get Secure! -> http://www.microsoft.com/security


--------------------
-Reply-To: "Fred Zelhart" <fred (AT) rzti (DOT) com>
-From: "Fred Zelhart" <fred (AT) rzti (DOT) com>
-Subject: Needing to migrate cluster to physically new machines with SQL2K
-Date: Tue, 1 Jul 2003 15:30:59 -0500
-Lines: 18
-Organization: RZ Technologies, LLC
-X-Priority: 3
-X-MSMail-Priority: Normal
-X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
-X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
-Message-ID: <#mhcOKBQDHA.3880 (AT) tk2msftngp13 (DOT) phx.gbl>
-Newsgroups: microsoft.public.sqlserver.clustering,microsoft.pu blic.windows.server.clustering
-NNTP-Posting-Host: 65.103.179.105
-Path: cpmsftngxa09.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftn gp13.phx.gbl
-Xref: cpmsftngxa09.phx.gbl microsoft.public.windows.server.clustering:592 microsoft.public.sqlserver.clustering:1446
-X-Tomcat-NG: microsoft.public.sqlserver.clustering
-
-We have a current 2-node Windows 2000 Advanced Server cluster running SQL 2K
-SP3. We are needing to physically replace the machines in the cluster
-(hardware upgrade). The new machines have Windows 2003 Advanced Server
-installed.
-
-I figured the easiest way to do this is to remove a node from the cluster
-and then add one of the new machines (windows 2003) to the cluster. Then do
-the same to the other node. It appears from various KB articles that a
-mixed OS environment of 2K & 2K3 are supported (KB313037). Is this correct?
-
-Is there any documentation already out there that covers doing this?
-
-Anyone already attempted and run in to problems? Any advice?
-
-Thanks.
-Fred Zelhart
-
-
-