Part 1 - Prepare Windows Cluster

Part 3 - Install and Configure NLB on WFE

part 4 - Install and configure SharePoint farm (3-tier) 

 

1. Install SQL 2008 R2 setup , make sure to select  New SQL Server failover Cluster

image

2. Click next , until reaching the below screen, select all features

image

3. Provide SQL Server a new Cluster name as below:

image

4. Place SQL resources in the SQL Group created previously

image

5. Assign SQL disks to the SQL Group

image

6. Give a proper SQL IP address for the clustered SQL instance :

image

7. For the service account , place a dedicated service account for the SQL services

image

Note: SQL Reporting cant be clustered.

8. Make sure to add the current user and to select mixed mode:

image

9. Make sure to point to the proper disk drives in the Data Directories tab:

image

10. Make sure to point to the proper disk drives in Analysis screen

image

11. Next to Finish.

12. Make sure you can connect to SQL Instance from management studio:

image

13. Join the other node, by running the setup and selecting

image

14. Click next until reaching to the below page, make sure the correct SQL Cluster name is provided

image

15. Install SP1 on each node (to consider high availability, make sure to install SP1 on the passive node) , from SQL Management Studio à help –> about check after SQL version it should be as below:

image