SharePoint 2013 Instance 1-build three-tier server farm 4-Configure DB Layer 2-Install SQL

Source: Internet
Author: User
Tags failover

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.