Configure SQL Server Standrad cluster

1.installationMicrosoft. Net FrameWork 3.5

Installing SQL Server 2014 requires first installing the Microsoft.NET FrameWork 3.5 feature,

Need to be installed for each node of the cluster. , run the "Add Rolesand features Wizard"

650) this.width=650; "title=" 1.png "style=" Float:none; "alt=" wkiom1sp9cbdkvluaamia4cu7fc013.jpg "src=" http:/ S3.51cto.com/wyfs02/m01/58/22/wkiom1sp9cbdkvluaamia4cu7fc013.jpg "/>

Hook-and-choose ". NETFramework3.5 Features"function , click on"Next"to continue the installation

650) this.width=650; "title=" 2.png "style=" Float:none; "alt=" wkiol1sp9opxthx5aaidpmvyn_i032.jpg "src=" http:/ S3.51cto.com/wyfs02/m01/58/1f/wkiol1sp9opxthx5aaidpmvyn_i032.jpg "/>

. NETFramework3.5 Features installed successfully,

The same method is installed on the secondary node to install the . NET Framework3.5 Features feature.

After both nodes have successfully installed the . NET Framework3.5 feature, start installing the SQL Server2014 Setup program .

2.installtion SQL Server Standrad (中文版)

on the primary node server, double-click the optical drive:

Click Install on the left installation screen, then click "New SQL serverfailover cluster Installation"

650) this.width=650; "title=" 3.png "style=" Float:none; "alt=" wkiol1sp9otbtli2aakwfgtv8is907.jpg "src=" http:/ S3.51cto.com/wyfs02/m02/58/1f/wkiol1sp9otbtli2aakwfgtv8is907.jpg "/>

650) this.width=650; "title=" 4.png "style=" Float:none; "alt=" wkiom1sp9cegykjgaal2zoljhjc214.jpg "src=" http:/ S3.51cto.com/wyfs02/m02/58/22/wkiom1sp9cegykjgaal2zoljhjc214.jpg "/>

650) this.width=650; "title=" 5.png "style=" Float:none; "alt=" wkiol1sp9osctgccaaoyd84b4fk142.jpg "src=" http:/ S3.51cto.com/wyfs02/m00/58/1f/wkiol1sp9osctgccaaoyd84b4fk142.jpg "/>

650) this.width=650; "title=" 6.png "style=" Float:none; "alt=" wkiom1sp9cej-glpaas4iyagzou136.jpg "src=" http:/ S3.51cto.com/wyfs02/m00/58/22/wkiom1sp9cej-glpaas4iyagzou136.jpg "/>

Here, you can select a named instance, and you need to enter SQL Server Network name:xxxxsqlcluster

Click "Next" to continue the installation.

650) this.width=650; "title=" 7.png "alt=" wkiol1sp-bwwezzsaapjg3ffs6i458.jpg "src=" http://s3.51cto.com/wyfs02/M01/ 58/1f/wkiol1sp-bwwezzsaapjg3ffs6i458.jpg "/>650) this.width=650;" title= "8.png" alt= "wkiol1sp-kvswjqzaapxz_ Ugyee948.jpg "src=" Http://s3.51cto.com/wyfs02/M02/58/1F/wKioL1Sp-kvSWJqzAAPxZ_ugyEE948.jpg "/>

in the Cluster Network configuration interface, cancel the hook option " DHCP " , and enter IP Address , Next Next Step

650) this.width=650; "title=" 10.png "alt=" wkiol1sp-rabmomtaalrwfjrz38535.jpg "src=" http://s3.51cto.com/wyfs02/M01/ 58/1f/wkiol1sp-rabmomtaalrwfjrz38535.jpg "/>

Use the same account "Mdc\administrator" for all SQL Server services and enter the password.

Click "Next" to continue installing SQL

650) this.width=650; "title=" 11.png "style=" Float:none; "alt=" wkiol1sp9oarpomsaaqgrbvc7t0917.jpg "src=" http:/ S3.51cto.com/wyfs02/m00/58/1f/wkiol1sp9oarpomsaaqgrbvc7t0917.jpg "/>

SQL Server authentication is not required here, select Windows authentication Mode, and add the current user on the specified SQL Server administrator .

Click "Next" to continue installing SQL Server

650) this.width=650; "title=" 12.png "style=" Float:none; "alt=" wkiom1sp9cnzxgt2aapfeyhrsik762.jpg "src=" http:/ S3.51cto.com/wyfs02/m00/58/22/wkiom1sp9cnzxgt2aapfeyhrsik762.jpg "/>

650) this.width=650; "title=" 13.png "style=" Float:none; "alt=" wkiol1sp9obxk0u9aaovoazhk3s122.jpg "src=" http:/ S3.51cto.com/wyfs02/m01/58/1f/wkiol1sp9obxk0u9aaovoazhk3s122.jpg "/>

650) this.width=650; "title=" 14.png "style=" Float:none; "alt=" wkiom1sp9cmtdvxfaatoxlfla1w621.jpg "src=" http:/ S3.51cto.com/wyfs02/m01/58/22/wkiom1sp9cmtdvxfaatoxlfla1w621.jpg "/>

"Close" completes the primary node SQL Server 2014 installation.

3.in the DeputyNode InstallationSQL Server

To log on to the secondary node operating system as a user (Mdc\administrator), run the SQL Server 2014 Setup program:

Point "Add node to a SQL Server failover cluster" adding the cluster nodes

650) this.width=650; "title=" 15.png "style=" Float:none; "alt=" wkiol1sp9ofbcpx6aaksejlai4y354.jpg "src=" http:/ S3.51cto.com/wyfs02/m02/58/1f/wkiol1sp9ofbcpx6aaksejlai4y354.jpg "/>

650) this.width=650; "title=" 16.png "style=" Float:none; "alt=" wkiom1sp9cryiqk3aalckdsoapm455.jpg "src=" http:/ S3.51cto.com/wyfs02/m01/58/22/wkiom1sp9cryiqk3aalckdsoapm455.jpg "/>

650) this.width=650; "title=" 17.png "style=" Float:none; "alt=" wkiol1sp9ofjrcekaao-g93agyu826.jpg "src=" http:/ S3.51cto.com/wyfs02/m02/58/1f/wkiol1sp9ofjrcekaao-g93agyu826.jpg "/>

650) this.width=650; "title=" 18.png "style=" Float:none; "alt=" wkiom1sp9cqilrp7aaqyemshujc356.jpg "src=" http:/ S3.51cto.com/wyfs02/m02/58/22/wkiom1sp9cqilrp7aaqyemshujc356.jpg "/>

650) this.width=650; "title=" 19.png "style=" Float:none; "alt=" wkiom1sp_fsxdqt5aako71nd-dg252.jpg "src=" http:/ S3.51cto.com/wyfs02/m02/58/22/wkiom1sp_fsxdqt5aako71nd-dg252.jpg "/>

650) this.width=650; "title=" 20.png "style=" Float:none; "alt=" wkiol1sp_rljqk_7aaljtpwr6wi597.jpg "src=" http:/ S3.51cto.com/wyfs02/m00/58/1f/wkiol1sp_rljqk_7aaljtpwr6wi597.jpg "/>

650) this.width=650; "title=" 21.png "style=" Float:none; "alt=" wkiol1sp9ojw9kxvaalvx8anvou346.jpg "src=" http:/ S3.51cto.com/wyfs02/m01/58/1f/wkiol1sp9ojw9kxvaalvx8anvou346.jpg "/>

650) this.width=650; "title=" 22.png "style=" Float:none; "alt=" wkiom1sp9cvxjasnaaq2jle3vkw109.jpg "src=" http:/ S3.51cto.com/wyfs02/m01/58/22/wkiom1sp9cvxjasnaaq2jle3vkw109.jpg "/>

Complete the secondary node installation.

Two nodes of SQL cluster installation complete

This article is from "What is our favorite" blog, please be sure to keep this source http://pxizhi.blog.51cto.com/5283742/1599208

Configuring SQL Server Standrad cluster