In this section we continue to configure the DB layer, such as the Red Place.
650) this.width=650; "title=" clip_image002 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image002" src= "Http://s3.51cto.com/wyfs02/M00/6A/A7/wKiom1UrhRnx8NN0AAEsK0kFnfM368.jpg" Width= "557" height= "455"/>
Server |
Host Name |
Memory |
Ip |
Database db#1 |
Srv-sql01 |
16G |
192.168.5.63 |
Database db#2 |
Srv-sql02 |
16G |
192.168.5.63 |
In the previous section we have established the failover cluster for Windows and the MSDTC service, this section we continue to install the SQL Failover Cluster service.
1. Create a new SQL Server failover cluster
Enter Server SRV-SQL01, in the SQL Installation Center, select the new SQL Server failover cluster installation
650) this.width=650; "title=" clip_image004 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image004" src= "Http://s3.51cto.com/wyfs02/M02/6A/A7/wKiom1UrhR2T31q2AADrcQQAsM4960.jpg" Width= "558" height= "/>" Environmental testing
650) this.width=650; "title=" clip_image006 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image006" src= "Http://s3.51cto.com/wyfs02/M01/6A/A7/wKiom1UrhR6AYGSMAAFpPDk1byk842.jpg" Width= "558" height= "420"/>
Continue detection, the network card binding sequence is found to have a warning
650) this.width=650; "title=" clip_image008 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image008" src= "Http://s3.51cto.com/wyfs02/M01/6A/A7/wKiom1UrhSOC3TDdAAF-xm7NMrg820.jpg" Width= "558" height= "421"/>
We can go to the Network adapter window and select Advanced Settings
650) this.width=650; "title=" clip_image010 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image010" src= "Http://s3.51cto.com/wyfs02/M02/6A/AB/wKiom1UrhaChfPCOAADMt-zd7uU068.jpg" Width= "470" height= "253"/>
Adjustment order
650) this.width=650; "title=" clip_image012 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image012" src= "Http://s3.51cto.com/wyfs02/M01/6A/A6/wKioL1UrhvfSSQ1RAAFTNL4ZYaE176.jpg" Width= "473" height= "589"/>
Re-detection can reveal that the warning has been lifted.
Continue Setup, enter the secret key
650) this.width=650; "title=" clip_image014 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image014" src= "Http://s3.51cto.com/wyfs02/M00/6A/A6/wKioL1Urhv2xAZRPAAEfVAqq9Ts734.jpg" Width= "558" height= "417"/>
Accept the License Terms
650) this.width=650; "title=" clip_image016 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image016" src= "Http://s3.51cto.com/wyfs02/M01/6A/A7/wKioL1Urhv-Q08uFAAFzdfWhGhM990.jpg" Width= "558" height= "417"/>
Select the SQL Server feature installation here
650) this.width=650; "title=" clip_image018 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image018" src= "Http://s3.51cto.com/wyfs02/M01/6A/AB/wKiom1UrhbeyubLNAAEwz4WYffg358.jpg" Width= "558" height= "418"/>
The selection function is as follows: (I change the installation directory to D drive here)
650) this.width=650; "title=" clip_image020 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image020" src= "Http://s3.51cto.com/wyfs02/M02/6A/A7/wKioL1Urhw2wyAvnAAGkNmmnjsU511.jpg" Width= "558" height= "466"/>
Functional Rule Detection
650) this.width=650; "title=" clip_image022 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image022" src= "Http://s3.51cto.com/wyfs02/M01/6A/AC/wKiom1UrhcjQFGh4AAEs3AMshcI776.jpg" Width= "558" height= "466"/>
Define the name of the SQL Server for the cluster, and later SharePoint needs to use this name to connect to the SQL cluster (I'll use the default instance name, change the instance root to D disk)
650) this.width=650; "title=" clip_image024 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image024" src= "Http://s3.51cto.com/wyfs02/M01/6A/AC/wKiom1UrhdTz_TePAAFbQyprBvw936.jpg" Width= "558" height= "465"/>
Confirm Space
650) this.width=650; "title=" clip_image026 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image026" src= "Http://s3.51cto.com/wyfs02/M01/6A/AC/wKiom1UrhdiByWW1AAEteNjsHqE163.jpg" Width= "557" height= "430"/>
Identify resource groups
650) this.width=650; "title=" clip_image028 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image028" src= "Http://s3.51cto.com/wyfs02/M02/6A/A8/wKioL1UrhyvQVgT3AAFpZ3eVdNI408.jpg" Width= "558" height= "428"/>
Select a clustered disk for the SQL data store
650) this.width=650; "title=" clip_image030 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image030" src= "Http://s3.51cto.com/wyfs02/M00/6A/AD/wKiom1UrheXC_rwSAAFn-F839Wg090.jpg" Width= "558" height= "430"/>
Define SQL cluster with IP
650) this.width=650; "title=" clip_image032 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image032" src= "Http://s3.51cto.com/wyfs02/M02/6A/AD/wKiom1UrherC0uEAAAESD6fqarE802.jpg" Width= "558" height= "429"/>
To configure the SQL service account, select the previously defined Xcloud\sql_service account
650) this.width=650; "title=" clip_image034 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image034" src= "Http://s3.51cto.com/wyfs02/M00/6A/AD/wKiom1UrhezTztaqAAFZ69FWweQ404.jpg" Width= "558" height= "429"/>
Select the authentication mode and SQL Administrator, and add the current SQL installation account here Xcloud\sql_install
650) this.width=650; "title=" clip_image036 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image036" src= "Http://s3.51cto.com/wyfs02/M01/6A/A8/wKioL1Urhz2xGaVTAAGGXT5RzIU695.jpg" Width= "558" height= "430"/>
Confirm Data Store Directory
650) this.width=650; "title=" clip_image038 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image038" src= "Http://s3.51cto.com/wyfs02/M02/6A/A9/wKioL1Urh03iREYKAAGA_7Prm3M635.jpg" Width= "557" height= "427"/>
650) this.width=650; "title=" clip_image040 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image040" src= "Http://s3.51cto.com/wyfs02/M02/6A/B3/wKiom1Urhurixuw0AAFfo24Z05g429.jpg" Width= "558" height= "426"/>
Detecting installation Rules
650) this.width=650; "title=" clip_image042 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image042" src= "Http://s3.51cto.com/wyfs02/M00/6A/AF/wKioL1UriDuilDwtAAE485IYEhc977.jpg" Width= "558" height= "428"/>
Last Select Install
650) this.width=650; "title=" clip_image044 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image044" src= "Http://s3.51cto.com/wyfs02/M02/6A/AF/wKioL1UriD3wFwHzAAFjoTcJ0CU688.jpg" Width= "558" height= "427"/>
Wait a while for the installation to complete successfully
650) this.width=650; "title=" clip_image046 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image046" src= "Http://s3.51cto.com/wyfs02/M02/6A/AF/wKioL1UriEmQIUFsAAGdDkb4K2s682.jpg" Width= "558" height= "414"/>
In the failover manager, you can see that the role of SQL Server has been added
650) this.width=650; "title=" clip_image048 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image048" src= "Http://s3.51cto.com/wyfs02/M01/6A/AF/wKioL1UriEui9vdLAABz73k4ioc395.jpg" Width= "558" height= "/>"
2. Add a SQL Server failover cluster node
Enter Server srv-sql02, select Add node to SQL Server failover cluster
650) this.width=650; "title=" clip_image050 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image050" src= "Http://s3.51cto.com/wyfs02/M00/6A/B4/wKiom1UrhwPgXSQYAADrzMkb7PY051.jpg" Width= "558" height= "245"/>
Select instances, where only default instances are optional
650) this.width=650; "title=" clip_image052 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image052" src= "Http://s3.51cto.com/wyfs02/M00/6A/AF/wKioL1UriFWR8gOcAAEHqNIGY18145.jpg" Width= "558" height= "419"/>
Confirm IP
650) this.width=650; "title=" clip_image054 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image054" src= "Http://s3.51cto.com/wyfs02/M01/6A/B4/wKiom1UrhwnRRwM1AAEYb7DJOME764.jpg" Width= "558" height= "419"/>
Confirm Service Management Account
650) this.width=650; "title=" clip_image056 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image056" src= "Http://s3.51cto.com/wyfs02/M01/6A/B0/wKioL1UriF_gVyDPAAEsxVgoYbU875.jpg" Width= "558" height= "417"/>
Last Select Install
650) this.width=650; "title=" clip_image058 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image058" src= "Http://s3.51cto.com/wyfs02/M00/6A/B0/wKioL1UriGSBfTPrAAFLwMvprO0888.jpg" Width= "557" height= "418"/>
Installation completed after some time
650) this.width=650; "title=" clip_image060 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image060" src= "Http://s3.51cto.com/wyfs02/M00/6A/B0/wKioL1UriGeSCSJ8AAGasCyIxGw765.jpg" Width= "558" height= "419"/>
3. SQL Cluster status Acknowledgement
Entering DNS Manager, you can discover that the DNS records for the cluster SQL name and IP have been automatically increased
650) this.width=650; "title=" clip_image062 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image062" src= "Http://s3.51cto.com/wyfs02/M01/6A/B4/wKiom1UrhxjQs90CAACHhqf_-uk488.jpg" Width= "420" height= "/>"
These virtual machines are also added to the Computers group in the ad
650) this.width=650; "title=" clip_image064 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image064" src= "Http://s3.51cto.com/wyfs02/M01/6A/B4/wKiom1UrhxnjMDanAADEA5nRW6Q513.jpg" Width= "503" height= "166"/>
4. Experiment Switch node
into Cluster Administrator, you can view the SQL owner node as SRV-SQL01 now
650) this.width=650; "title=" clip_image066 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image066" src= "Http://s3.51cto.com/wyfs02/M00/6A/B4/wKiom1UrhxvCWXjqAABivH1AtFQ905.jpg" Width= "558" height= "/>"
We right-click the move-select node
650) this.width=650; "title=" clip_image068 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image068" src= "Http://s3.51cto.com/wyfs02/M00/6A/B5/wKiom1UrhyPAmWBdAAD6lmwdonI280.jpg" Width= "534" height= "355"/>
Select Node Srv-sql02
650) this.width=650; "title=" clip_image070 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image070" src= "Http://s3.51cto.com/wyfs02/M01/6A/B0/wKioL1UriHSgcnTxAADG_1Y4USM783.jpg" Width= "408" height= "498"/>
Discover owner node switched to SRV-SQL02
650) this.width=650; "title=" clip_image072 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image072" src= "Http://s3.51cto.com/wyfs02/M01/6A/B5/wKiom1UrhyzzXMeXAAByAi4V0m8528.jpg" Width= "558" height= "136"/>
When you try to close srv-sql01, you can see that both the DTC and the SQL Service node automatically switch srv-sql01.
650) this.width=650; "title=" clip_image074 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image074" src= "Http://s3.51cto.com/wyfs02/M02/6A/B0/wKioL1UriH2h8H02AABiU13Dn74873.jpg" Width= "558" height= "/>"
Node item can view node status
650) this.width=650; "title=" clip_image076 "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt = "clip_image076" src= "http://s3.51cto.com/wyfs02/M02/6A/B0/wKioL1UriICgfE2RAABHb4dwnA4707.jpg" width= "558" height = "/>"
In this way, a high-availability SQL cluster based on MSFC is ready for installation.
The DB layer configuration is complete.
This article is from the "Iron Fist of the Invincible Speaker" blog, please be sure to keep this source http://yaojiwei.blog.51cto.com/762134/1631924
SharePoint 2013 Instance 1-build three-tier server farm 4-Configure DB Layer 2-Install SQL