In this post i will show how to add Sql cluster node.
MS Sql 2008 R2 SP1 on Windows 2012 R2 standard
Step to add nodes
* Install .net framework 3.5 feature from server manager
link for .net framework 3.5 installation
* Powershell to install Cluster automation
open powershell as administrator
use below command
add-windowsfeature RSAT-Clustering-AutomationServer
This command is required for sql server 2008 installation on 2012 R2.
Related error is command is not used
Cluster node failed
cluster service verification faileda
* Add new server to failover cluster first
Go to failover cluster manager click nodes -- Add node
Click next
Add Server name click next
Select add all eligible storage and click next
Click finish
new node added
* Mount Sql iso or insert dvd
Double click Setup.exe
Click Installation -- Add node to a SQL Server failover cluster
Click ok
Click next
Accept license and Click next
Click install
Click next (on this step if you get cluster failed error check the command i mentioned in beginning of this post)
Select the instance name click next
Enter Sql service account password and click next
Click next
Sql installation on new node completed.
Restart the server and test the failover through failover cluster manager.
Done....
Next : How to update MS SQL 2008 R2 SP1 to SP2
0 comments: