SQL SERVER HIGH AVAILABILITY CONFIGURATION – PART1
Prerequisite for SQL Server Always On Setup
- All Nodes are in Domain Network
- Static IP should be assigned on all nodes
- Windows Failover Cluster Roles should be installed on all nodes
- SQL Server of same version should be installed on all nodes
- All Ports should be allowed in Windows firewall
- SQL Server services should be run on same account
- SQL Server Agent should be run on same account
- .NET framework 3.5 with sp1 should be installed on all nodes
Installation of Failover Clustering
To installation of clustering services, open the server manager, go to manage to add roles and features
Click on Add Roles and Features, A screen will open click on next button four times, select Failover Clustering, click on Add features, and then click on next button.
Click on install button, and wait for some time, it will get installed.
Repeat this step on other server/node which you want to add for failover clustering.
Validation and Configuration of Cluster
Validation of Configuration
After installing the Failover Clustering on Node 2 go to Server Manager, click on tools and select Failover Cluster Manager. Failover Cluster Manager Dashboard will open as shown below
In right side of manager dashboard click Validate Configuration, a window will open just read these steps and click on next button, in next screen enter the name of Server/Node ( both Node), click on Browse and select the both Node and then click on next button two times,
In next screen leave everything by default and click on next
In this step it will validate all the settings and configuration of failover clustering
Once the validation successfully run click on finish button. You can also click on view report to check the report of configuration and information related to this.
Once we click on finish button it will open a new window for next step, Give the name of Cluster (a simple name) and enter the IP address for Cluster (IP should be from same network) and click on next button.
Creating Cluster
Now Open the Cluster manager dashboard and Click on Create Cluster, a screen will open click on next button.
In next screen click on Browse button and both the nodes (Node1 and Node2) as shown in below image and click on next button.
Here Type the name of cluster and give IP address for cluster as shown in below image and click on next button.
In next screen uncheck Add all eligible storage to the cluster (we will add manually), click on next button
In next step cluster creation process starts as shown below:
Once the process completes message will appear you have successfully completed the Create Cluster Wizard. Click on finish button to close this.
Now Cluster Manager Dashboard will show like below image.