SQL Server 2008r2 cluster (iii)

17. Install "Failover Clustering" function on SQL01 and SQL02, open Server Manager, select "Add Features" to find and tick the failover Clustering option on the Feature list, click Next to install;

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/84/00/wKioL1eDNeXjjbDTAACPp40Rrbw979.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/84/01/wKiom1eDNebzmThCAADmiDNjSsE396.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/84/00/wKioL1eDNebDXWn9AAA3nWOlTeg316.jpg "/>650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/84/00/wKioL1eDNefQgNZIAAA2PIS7tYQ178.jpg "/>

18. Open the Failover Cluster Manager under the Server Start Menu management tool;

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/84/01/wKiom1eDNefBC8wfAAFHDXZvfoE131.jpg "/>

19. Click Verify configuration in the Failover Cluster Manager interface to verify that your server meets the cluster requirements;

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/84/00/wKioL1eDNeiCSvMWAAEVXp63-9U080.jpg "/>

20. Click Next on the Verify Configuration Wizard interface;

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/84/01/wKiom1eDNejSW3QAAADzdMIkWmU551.jpg "/>

21. Select the two servers of the cluster SQL01 and SQL02 to add to the authentication list;

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/84/01/wKiom1eDNemg-6LzAACvAlQTtug660.jpg "/>

22, in the "Test options Interface" will have a description of what to test, select "Run All tests" click Next;

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/84/00/wKioL1eDNemBe1rrAADJXBsR-r8829.jpg "/>

23, in the determination of the interface, will show the server information to be tested and test content click "Next";

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/84/00/wKioL1eDNeqRJTwAAADKvBd_u0w607.jpg "/>

24, in the "Summary" screen can see the results of the test, click on the "View report" can see more detailed information, verify that the "Test completed successfully, configure the appropriate cluster" prompt on the back screen, click to complete the verification;

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/84/01/wKiom1eDNerjdBdPAADJ6-D0tSY622.jpg "/>

25, after the verification passed, we will create the cluster, click the "Create cluster" option to enter the wizard interface to create the cluster click "Next";

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/84/00/wKioL1eDNevikKx2AAECBZ4fCWA372.jpg "/>

25, in the "Select Server" interface, select the server you want to create the cluster;

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/84/01/wKiom1eDNezBAELxAACopWG-ubo638.jpg "/>

26, enter the cluster name and the management address of the cluster in the "Manage Cluster access point" interface, click Next.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/84/00/wKioL1eDNezTr9t9AADI-li5ne8615.jpg "/>

27, in the "Create cluster determination" screen can see what we just set up and two cluster node server, click Next to start creating the cluster;

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/84/01/wKiom1eDNe2Te1KjAACm8Ex3VIU179.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/84/01/wKiom1eDNe3AxRvUAAB7Hav1khQ977.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/84/00/wKioL1eDNe6itVXZAAC4rRv3jEY275.jpg "/>

28. After successful cluster creation, we need to create a "Distributed Transaction adjuster (DTC)" (Microsoft Distributed Transaction Coordinator (MS DTC) is a transaction manager that allows client applications to include multiple different data sources in a transaction. MS DTC coordinates the submission of distributed transactions between all servers that have been enlisted in the transaction. )

This article from "Nuzhihai" blog, reproduced please contact the author!

SQL Server 2008r2 cluster (iii)