網頁

2012年4月2日 星期一

Install SQL Server 2008 R2 Cluster (part 3 of 4)

(4).Install SQL Service into Cluster
  • Execute “SQL Server 2008 R2” installation program, the SQL Server Installation Center will show up. Click “Installation” in left menu --> “New” SQL Server failover cluster installation”
    ScreenHunter_02 Feb. 09 14.35
  • Click “OK” button if Setup doesn’t identify any problem.
    ScreenHunter_04 Feb. 09 14.36
  • Enter the product key next to click “Next > “ button
    ScreenHunter_05 Feb. 09 14.37
  • Enable “I accept the license terms” check box next to click “Next > “ button
    ScreenHunter_06 Feb. 09 14.38
  • Click “Install” button
    ScreenHunter_07 Feb. 09 14.39
  • Click “Next > ” button and ignore error message.
    ScreenHunter_15 Feb. 09 14.55
  • Click “Select All” button because I will install All SQL componentScreenHunter_16 Feb. 09 14.58
  • Click “Next > “ button if no any change directory now.ScreenHunter_17 Feb. 09 15.04
  • Key in SQL Server Network Name as “SQLCluster01” and select “Default instance” option because it is the first SQL installation. Click “Next > “ button if no need to change “default” Instance ID and root directory.ScreenHunter_18 Feb. 09 16.15
  • Click “Next > “ buttonScreenHunter_19 Feb. 09 16.19
  • Select SQL Server cluster resource group name as “SQL Server (MSSQLSERVER) next to click “Next > “ buttonScreenHunter_20 Feb. 09 16.21
  • Release which Cluster Disk has enough space next to select one Cluster Disk as “Cluster Disk 2” and click “Next > “ buttonScreenHunter_21 Feb. 09 16.22
  • Enable “IPv4” check box', disable “DHCP” check box next to key in a IP address as “10.11.101.83” and click “Next >“ buttonScreenHunter_22 Feb. 09 16.26
  • Select “Use service SIDs” option next to click “Next > “ buttonScreenHunter_23 Feb. 09 16.39
  • Browse one Domain Account as “CORP\sqlservice” and key in its password for SQL Server Agent/Database Engine/Analysis Services/Reporting Services next to click “Next > “ buttonScreenHunter_24 Feb. 09 16.47
  • Select “Mixed Mode” and assign a password for sa, next to click “Add Current User” buttonScreenHunter_26 Feb. 09 16.49
  • So does that the “CORP\administrator” will be added. If no need to add other account,please click “Next > “ buttonScreenHunter_29 Feb. 09 16.50
  • Click “Add Current User” for Analysis Services Administrators.ScreenHunter_30 Feb. 09 16.55
  • So does that the “CORP\administrator” will be added. If no need to add other account,please click “Next > “ buttonScreenHunter_31 Feb. 09 16.55
  • Click “Next > “ buttonScreenHunter_33 Feb. 09 16.56
  • Click “Next > “ buttonScreenHunter_34 Feb. 09 16.56
  • Click “Next > “ buttonScreenHunter_35 Feb. 09 16.56
  • Click “Install” button if the summary is as your willingScreenHunter_36 Feb. 09 16.57
  • Click “Close” button if get the successful message as “Your SQL Server 2008 R2 failover cluster installation is complete”ScreenHunter_38 Feb. 09 17.18
(5).Verify SQL Cluster
  • Open Failover Cluster Manager to realize whether "SQL Server (MSSQLSERVER)" is added into the Services and Applications. When click "SQL Server (MSSQLSERVER)", we can know who take over this SQL Service, that is Current Owner : TEST-SQL-01
  • In Nodes, click "TEST-SQL-01" to know SQL Server status is online now.

  •  Click "Storage" to realize SQL Server install on Cluster Disk 2 now.


Since 2010 Design by Davidwa
©Copyright Davidwa Inc. All rights reserved.