Re: MSDTC Troubles, Do I Even Need It?

All qs have been answered by Rodney. I wanted to shed some light on the last qs

> Finally, a bonus question. There seems to be a lot of confusion about
> how to upgrade a new node to SQL Server SP3 when the other node already
> has it applied. What is the process?


I am assuming that you are adding a new node to the cluster and the old node has SQL Server 200 0 + SP3 install. The process is as follows:

1) Install the operating system on the new node.
2) Join the existing cluster. After joining the cluster, as a test moving the Cluster group (assuming it only has the Quorum, Cluster IP address and Cluster networ name resources) to the new node. If this step succeeds,
go to next steps. Do not test failing SQL Server to the new node yet.
3) Run the Setup program on old node and add new node to the failover cluster. For more information, see How to add nodes to an existing virtual server (Setup).
4) Make sure both nodes are up and running. Do not failover SQL Server from old node to new node. Run SP3a setup on old node and the setup will automatically install it on the new node.
5) After setup is complete, reboot any/all node as required
6) Test failover

How to add nodes to an existing virtual server (Setup)
--------------------------------------------------------------------------------------
1 )On the Welcome screen of the Microsoft SQL Server Installation Wizard, click Next.
2) On the Computer Name screen, click Virtual Server and specify the virtual server to which you want to add a node. Click Next.
3) On the Installation Selection screen, click Advanced options. Click Next.
4) On the Advanced Options screen, click Maintain a virtual server for failover clustering. Click Next.
5) On the Failover Clustering screen, click Next.
You do not need to enter an IP address.
6) On the Cluster Management screen, select the node and click Add.
7)If the node is listed as unavailable, you must modify the disk resources in the cluster group of the virtual server so the disk is available for the node you want to add to the Microsoft® SQL Server? configuration. Click
Next.
8)On the Remote Information screen, enter login credentials for the remote cluster node that has administrator privileges on the remote node of the cluster. Click Next.
9)On the Setup Complete screen, click Finish.


HTH,

Best Regards,

Uttam Parui
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.

Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx


.

Relevant Pages

  • RE: Error Message Evicting a Node
    ... Was the node that you wanted to evict shutdown when you evicted it from cluster administrator? ... I hope before evicting the node, you ran SQL Server setup on the upgraded node and removed the node that you wanted to evicted. ... click Virtual Server and specify the name of the server from which to remove the node. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Clustering with W2K3 and SQL 2005 (64bit) - best practice setup
    ... can run on 3 out of 4 of the 4-node setup. ... Each virtual server must be an instance. ... You can only have one default instance per cluster and the rest have to be named instances. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Create an new Instance in a clustered SQL2005
    ... When I run the setup there is no choice of Virtual server, ... I have setup a clustered SQL2005 with a default instance. ... Now I want to add 3 more instances to my cluster. ... to a different folder than the first install. ...
    (microsoft.public.sqlserver.clustering)
  • RE: Clustering H.E.L.P.
    ... For training, demo, support purposes, one could setup a cluster using Virtual Server 2005. ... Using Microsoft Virtual Server 2005 to Create and Configure a Two-Node Microsoft Windows Server 2003 Cluster ...
    (microsoft.public.sqlserver.clustering)
  • Re: Default or named instances??
    ... I've setup the cluster and tried to install the second instance as default ... According to your explanation about the relationship between SQL instance ... and virtual server I would change the analogy to say I could treat the ...
    (microsoft.public.sqlserver.clustering)
Loading