Add a node to an existing two-node SQL Server 2008 R2 Cluster

Add a node to an existing two-node SQL Server 2008 R2 Cluster

如何新增一個節點到已經存在的SQL Server 2008 R2 Cluster

Lab VMs:
1.DC (Windows 2003)
2.iSCSITarget (Windows Storage Server 2008 R2 SP1)
3.SQL1 (SQL Server 2008 R2 on Windows 2008 R2 SP1, existing SQL Cluster Node1)
4.SQL2 (SQL Server 2008 R2 on Windows 2008 R2 SP1, existing SQL Cluster Node2)
5.SQL3 (only Windows 2008 R2 SP1 installed before join SQL Cluster)

We want to add a new node(SQL3) to an exist two-node SQL Server Cluster

[Action Plan]
1.Ensure that All VMs are turned on(include SQL3) and connected to the network or virtual network
2.Ensure that you have a normal functioning failover cluster instance
確認現有的SQL Server Cluster運作正常,執行failover測試一下

3.on SQL3
configure ip address for public network
configure ip address for heartbeat network
configure ip address for iSCSI network


4.on SQL3
(1)Add Role and role service
add Application Role and enable Role Service:Distributed Transactions
[V]Distributed Transactions
[V]Incoming Remote Transactions
[V]Outgoing Remote Transactions

(2)Enable Feature
Enable [Failover Clustering] feature

5.on SQL3
Join AD Domain and reboot

6.on iSCSITarget
add SQL3 IP Address(for iSCSI) to [iSCSI Initiator] tab on each exist Targets(Quorum,DTC,SQL) properties

7.on SQL3
configure shared disk using iSCSI Initiator
and verify that the volumes are visiable with off-line status in the Disk Management node of the Server Manager console.(you don't have to configure or verify drive letter)

8.on SQL1
In the Failover Cluster Manager console, right click [Nodes] node and click [Add Node], on the Select Servers page, enter SQL3



按下完成之後繼續加入新節點的作業,最後也會順利完成,但是也會出現一些找不到SQL相關的DLL警告,這是因為這個節點還沒有安裝SQL Server


9.on SQL3
run SQL Server 2008 R2 setup.exe join SQL3 to exist SQL Cluster
(1)Insert the SQL Server installation media, and from the root folder, double-click Setup.exe
(2)When prerequisites are installed, the Installation Wizard will launch the SQL Server Installation Center. To add a node to an existing failover cluster instance, click Installation in the left-hand pane. Then, select Add node to a SQL Server failover cluster




Detail procedure you can reference follow URL:
To add a node to an existing SQL Server failover cluster
Add a Node to an Existing Failover Cluster in SQL Server 2008 (SQL Server Video)

10.Configuring the Windows firewall to allow SQL Server Access
allow follow program
C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQL2K8R2\MSSQL\Binn\sqlservr.exe

Configuring the Windows Firewall to Allow SQL Server Access


Comments (0)

Skip to main content