SQL Cluster Experiment (II)

6) MCCs cluster installation

Close Node 2 first, and start Node 2. Then, on node 1, open Server Manager to add the failover Clustering feature.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/46/CA/wKiom1P0hwTwzy56AAHEtm1MJdI603.jpg "style=" float: none; "title=" snap051.jpg "alt=" Wkiom1p0hwtwzy56aahetm1mjdi603.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/46/CB/wKioL1P0iCCw8xHBAAJl5-g2Gsk526.jpg "style=" float: none; "title=" snap052.jpg "alt=" Wkiol1p0iccw8xhbaajl5-g2gsk526.jpg "/>

The same action is then performed on Node 2. Two nodes after the Failover Clustering feature is installed, on Node 1, open failover Cluster Manager to create a new cluster

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/46/CB/wKiom1P0jFzikjSVAAQtPJQkzVw712.jpg "style=" float: none; "title=" snap053.jpg "alt=" Wkiom1p0jfzikjsvaaqtpjqkzvw712.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/46/CD/wKioL1P0jXTQZOikAAFU4EZ-u-U930.jpg "style=" float: none; "title=" snap054.jpg "alt=" Wkiol1p0jxtqzoikaafu4ez-u-u930.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/46/CB/wKiom1P0jFzwfdjAAAHq8IMIJqs492.jpg "style=" float: none; "title=" snap055.jpg "alt=" Wkiom1p0jfzwfdjaaahq8imijqs492.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/46/CD/wKioL1P0jXXTIFbQAAGvIZMVOv4280.jpg "style=" float: none; "title=" snap056.jpg "alt=" Wkiol1p0jxxtifbqaagvizmvov4280.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/46/CB/wKiom1P0jF3wFPaRAAKLonMfQTk270.jpg "style=" float: none; "title=" snap057.jpg "alt=" Wkiom1p0jf3wfparaaklonmfqtk270.jpg "/>

When you are finished, create the MSDTC service, also in the Failover cluster console, right-click "Services and Applications" to open "Configure services or applications" to configure

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/46/CD/wKioL1P0jwTDoh5tAAHtiUA1Mww927.jpg "style=" float: none; "title=" snap058.jpg "alt=" Wkiol1p0jwtdoh5taahtiua1mww927.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/46/CB/wKiom1P0je6SLhZFAAGXBYFmw_4204.jpg "style=" float: none; "title=" snap059.jpg "alt=" Wkiom1p0je6slhzfaagxbyfmw_4204.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/46/CD/wKioL1P0jwezVEyAAAGKXMZlo28023.jpg "style=" float: none; "title=" snap060.jpg "alt=" Wkiol1p0jwezveyaaagkxmzlo28023.jpg "/>

Manually switch the MSDTC Resource group movement from one node to another after the configuration is complete. The move operation can be repeated several times. Finally, you can shut down the MSDTC active node and view the status of MSDTC on another node

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/46/CD/wKioL1P0kGbD0WauAASPsb9sUcE757.jpg "style=" float: none; "title=" snap061.jpg "alt=" Wkiol1p0kgbd0wauaaspsb9suce757.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/46/CB/wKiom1P0j06Qr6VVAADXZmZyTa8521.jpg "style=" float: none; "title=" snap062.jpg "alt=" Wkiom1p0j06qr6vvaadxzmzyta8521.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/46/CD/wKioL1P0kGfAA1gZAAPOzFcNk94518.jpg "style=" float: none; "title=" snap063.jpg "alt=" Wkiol1p0kgfaa1gzaapozfcnk94518.jpg "/>

7) SQL 2008 cluster installation

You first need to install the. NET Framework 3.5 SP1 feature on each node, or you will receive an error. Then add the SQL ISO file

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/47/0B/wKioL1P10vmis7JPAAIKPXLyA6s266.jpg "title=" 46.jpg "alt=" Wkiol1p10vmis7jpaaikpxlya6s266.jpg "/>

Then OK, after connecting the disc, run SETUP.EXE, select Install new SQL Server failover cluster

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/47/0B/wKioL1P112PRIZmmAAEMRmTrjZ8566.jpg "style=" float: none; "title=" snap065.jpg "alt=" Wkiol1p112prizmmaaemrmtrjz8566.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/47/09/wKiom1P11kvDwn5cAAJfu6qLuxg873.jpg "style=" float: none; "title=" snap067.jpg "alt=" Wkiom1p11kvdwn5caajfu6qluxg873.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/47/0B/wKioL1P112SSE3rjAAIhBWvGP9M103.jpg "style=" float: none; "title=" snap068.jpg "alt=" Wkiol1p112sse3rjaaihbwvgp9m103.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/47/09/wKiom1P11kzjZQ-_AAGarIBgBMc571.jpg "style=" float: none; "title=" snap070.jpg "alt=" Wkiom1p11kzjzq-_aagaribgbmc571.jpg "/>

For the two warnings, where the cluster server is unable to access the Internet, there is a "Microsoft.NET application Security" warning that can be ignored. The other one needs to be modified manually, and this warning occurs because the domain network is not the first bound network. First check the binding order as

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/47/0B/wKioL1P12EXgpWABAAFazVFb8jg957.jpg "title=" Snap072.jpg "alt=" Wkiol1p12exgpwabaafazvfb8jg957.jpg "/>

Network order Yes, finally, we found that after the cluster software was installed, the operating system has a hidden virtual network card, the name of this network adapter is microsoftfailover Cluster virtual Adapter. With the Ipconfig/all command, you can see this NIC

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/47/0A/wKiom1P117jhmsq6AAF8kF31NXw696.jpg "title=" Snap073.jpg "alt=" Wkiom1p117jhmsq6aaf8kf31nxw696.jpg "/>

Then use WMIC nicconfig get description, Settingid command to see the UUID of this NIC, and then run regedit in Hkey_local_machine\system\currentcontrolset\ Bind in the Services\tcpip\linkage path modifies the order of the Registry network bindings

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/47/0B/wKioL1P12rSx2w4HAADMrhxqjXo414.jpg "style=" float: none; "title=" snap074.jpg "alt=" Wkiol1p12rsx2w4haadmrhxqjxo414.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/47/0A/wKiom1P12ZyxFpnvAAJRafiTbmo606.jpg "style=" float: none; "title=" snap075.jpg "alt=" Wkiom1p12zyxfpnvaajrafitbmo606.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/47/0B/wKioL1P12rXhtrfzAAERMS0tvrk515.jpg "style=" float: none; "title=" snap076.jpg "alt=" Wkiol1p12rxhtrfzaaerms0tvrk515.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/47/0B/wKioL1P12rWwF63cAADymzk3LLk563.jpg "style=" float: none; "title=" snap077.jpg "alt=" Wkiol1p12rwwf63caadymzk3llk563.jpg "/>

Then continue to install, in addition to the following a few pictures need attention, the other only need to default the next step is good (of course, you can also set the other to do)

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/47/0A/wKiom1P13P_hDpKuAAM2zdoJdUs919.jpg "style=" float: none; "title=" snap078.jpg "alt=" Wkiom1p13p_hdpkuaam2zdojdus919.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/47/0A/wKiom1P13P-zrAAPAAL186sl1fk013.jpg "style=" float: none; "title=" snap079.jpg "alt=" Wkiom1p13p-zraapaal186sl1fk013.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/47/0B/wKioL1P13hjjDUKnAAImkdPPXnI707.jpg "style=" float: none; "title=" snap080.jpg "alt=" Wkiol1p13hjjduknaaimkdppxni707.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/47/0C/wKioL1P13hiTC1m7AANthQX2hc0760.jpg "style=" float: none; "title=" snap081.jpg "alt=" Wkiol1p13hitc1m7aanthqx2hc0760.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/47/0A/wKiom1P13QDT_pDdAAMu95W4lO0902.jpg "style=" float: none; "title=" snap082.jpg "alt=" Wkiom1p13qdt_pddaamu95w4lo0902.jpg "/>

After the installation is complete, tea in the organizer to see if the installation is successful

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/47/0C/wKioL1P15mqB-rZ6AAQVScp047c363.jpg "title=" Snap083.jpg "alt=" wkiol1p15mqb-rz6aaqvscp047c363.jpg "/> Then installs the database for node 2, and then runs SETUP.EXE to install the CD-ROM as above. The rest of the steps are just as good as the next step. Just pay attention to the password you need to enter

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/47/0D/wKiom1P17-WB6iYvAAJfhuDpoRg082.jpg "title=" Snap085.jpg "alt=" wkiom1p17-wb6iyvaajfhudporg082.jpg "/> Then proceed directly to the next installation until completed.

This article is from the "Guo Kun" blog, make sure to keep this source http://guo12.blog.51cto.com/9273463/1543315