Add New Node in SQL Server 2005 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Add New Node in SQL Server 2005

I want to setup a 3 nodes with 4 instances SQL Cluster. However, after finishing the SQL Cluster, if I want to add a new SQL server in the cluster, how could I install a SQL server in my new server without adding new instance. Then, I could failover to have 4 nodes with 4 instances.<br /><br />Thx for your help!!!<br /><br />Thx[<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />][<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />]
Add the node to the windows cluster as normal. Then run the SQL Setup program on the new node – you will be given the option to add a new node to the virtual server/instance.
Thx for your help! However, when I add a new node to the virtual server in the cluster by SQL setup, I must also create a new instance. How could I add a new node without adding a new instance? thx
quote:Originally posted by kevinngcc Thx for your help! However, when I add a new node to the virtual server in the cluster by SQL setup, I must also create a new instance. How could I add a new node without adding a new instance? thx

Hi there, You’re confusing SQL Server Instances with Cluster nodes. A node is a Windows Server installation, you add servers through Cluster manager on your cluster. An SQL Server instance is an installation of SQL Server. To move from a 3-node cluster to a 4-node cluster you need to get another machine, install windows server and add it to the cluster.
I think there may be more to this question. It is not difficult to add the new node to the windows cluster, but is there anything you need to do to the node to allow the existing SQL instances to failover to it? I think this may be the way –http://msdn2.microsoft.com/en-us/library/ms191545(en-US,SQL.90).aspx – also listed in books online as Add or Remove Nodes in a SQL Server 2005 Failover Cluster (Setup). I haven’t tried this yet, but am working on getting test cluster equiptment to give it a go…
]]>