Mots clés Technorati : ,,,,

Part I – Before we start

Part II – Creating Windows Cluster

Part III – Clustering MSDTC

Part IV – Installing the first SQL Server Cluster Node

Part V – Adding the second node

Part VI – Post installation tasks

 

1 Using the CLSSetup account that have the privileges to join computers to domain and configured as Local Administrator on each node open a session and run the setup program of SQL Server 2008 R2 
  image
2 Click Yes on the User Access Control message if it’s appear
  image
3 Select the Installation page and then click New SQL Server failover cluster installation
  image
4 on the Setup Support Rules verify that all tests are passed and then click Ok
  image
5 Type you Product Key and then click Next
  image
6 Check  I accept the license terms
Click Next
  image
7 On the Setup Support Files click Install
  image
8 When Support files are installed a new rules check will be processed by the setup program ensure that all tests are passed and then click Next
  image
9 Select the features that will be installed and the click Next.

Note : SSRS is not cluster aware 
  image
10 On the Instance Configuration page type the Network Name that will be used for your Clustered SQL Server  Instance , type an instance ID if you won’t use the default name MSSQLSERVER and then click Next
  image
11 Click Next on the Disk Space Requirements Page
  image
12  
  image
13 Select the Shared Disks that will depend on your SAL Server Cluster Group  and then click Next
  image
14 Type the virtual IP Address that will be used for your SQL Server Cluster
Click Next
  image
15 Click Next on the Cluster Security Group page
  image
16 Type the account names and their passwords for the services accounts that will be used   
 
  image
17 Click on the Collation tab if you want to change the default collation of the server by clicking the Customize button
Click  Next
  image
18 On the Database Engine Configuration Page choose your Authentication Mode, type the password for the sa account if you choose Mixed Mode.
Add the AD users or groups that will have the sysadmin role.
  image
19 Click Data Directories Tab and then configure the different drive for each kind of data that will be host on the nodes and then click Next
  image
20 Click Next on the Error Reporting Page
  image
21 Click Next on the Cluster Installation Rules
  image
22 Click Install on the Ready to Install Page
  image
23 Wait for the Installation progress
  image
24 Click Close on the Complete Page
  image
25 From the Failover Cluster Manager verify that all resources was created and are Online on the first node  
  image

0 commentaires