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
   確認所有VM都開機
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

 

 目前已經存在的節點是SQL2K8R2C1,SQL2K8R2C2

 要加入的節點是SQL2K8R2C3

 

 只需要輸入SQL啟動帳戶的密碼

 


 Detail procedure you can reference follow URL:
 To add a node to an existing SQL Server failover cluster
 http://msdn.microsoft.com/en-us/library/ms191545(v=sql.105).aspx#Add
  Add a Node to an Existing Failover Cluster in SQL Server 2008 (SQL Server Video)
  http://msdn.microsoft.com/en-us/library/ee915053(v=sql.100).aspx

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
http://msdn.microsoft.com/en-us/library/cc646023(v=sql.105).aspx