SharePoint Server 2013 bis: Preparing the database

in the previous article, we have The journey to SharePoint was set sail, and we were well prepared for our hardware software and system requirements. the deployment of SharePoint server (Foundation, Standard, and Enterprise Edition) must have SQL Server, in which we will detail the database preparation, deployment, The required permissions and firewall ports, and so on.

1.  Create users and Groups

Many people use the administrator account when doing experiments , but in the enterprise production environment very few customers will give such a permission to you, so in the experimental process, we recommend that you try to simulate the production environment, Understand the principle of least privilege required to deploy different products.

• Create to start SQL Service Account SQLService, ensure that the "Password never Expires", otherwise the default password expires, SQL- related services will not be able to run the normal operation would affect normal use of SharePoint;

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/57/54/wKioL1SYA2HAARY_AAFPDvtFL7A102.jpg "title=" 1.png " alt= "Wkiol1sya2haary_aafpdvtfl7a102.jpg"/>

• Create The SQL Administrators group sqladminsand adds SQLService to the group;

• Create SharePoint Administrator SPAdminand add it to the SQLAdmins group (you must ensure that SharePoint administrators have access to SQL).

• will be The SQLAdmins Group is added to the database server and the SharePoint server's local Administrators group.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/57/56/wKiom1SYAsPjp_K7AAHoumFDW50204.jpg "title=" 2.png " alt= "Wkiom1syaspjp_k7aahoumfdw50204.jpg"/>

2.  installationSQL Server SP1

Create the required account, then start installing our database SQL Server SP1, the installation of SQL is relatively simple, so I only cut some of the key figures after all analysis and analysis.

• installing . Net Framework3.5, which can be installed through the Add Roles and Features wizard, requires that you specify an alternate source path, that is, the path to the disc (E:\sources\sxs), or it will automatically Internet Download or installation failed.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/57/54/wKioL1SYA3ahJb3nAAQrwNd8MYE063.jpg "title=" 3.png " alt= "Wkiol1sya3ahjb3naaqrwnd8mye063.jpg"/>

• Run SQL Installer, on the SQL Server Installation Center page, click "Install"-"new SQL Server Standalone installation or add features to an existing installation"

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/57/54/wKioL1SYA4CBuwPeAALFgOy8no8254.jpg "title=" 4.png " alt= "Wkiol1sya4cbuwpeaalfgoy8no8254.jpg"/>

• after entering the product key according to the wizard and checking the "license Terms", the Product update page can be updated to the latest patches according to your needs, my installation package is the SP1 will not be updated. Click "Next"

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/57/56/wKiom1SYAuSiWAyYAAKFqcah8To248.jpg "title=" 5.png " alt= "Wkiom1syausiwayyaakfqcah8to248.jpg"/>

• In the Support rule checking page, make sure that all checks are passed, where the firewall is not closed and the appropriate ports are open for installation. Click "Next"

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/57/54/wKioL1SYA5eQsDkLAAN_onofx3E638.jpg "title=" 6.png " alt= "Wkiol1sya5eqsdklaan_onofx3e638.jpg"/>

• On the Feature Selection page, select the features that must be installed and modify the shared features directory, as

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/57/54/wKioL1SYA6CSmIu5AASlvCnlLE4983.jpg "title=" 7.png " alt= "Wkiol1sya6csmiu5aaslvcnlle4983.jpg"/>

• on the Instance configuration page, modify the instance according to the actual situation ID and root directory, remember that the instance must not exist in the C disk, and the root directory where the partition space must be sufficient. Click "Next"

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/57/57/wKiom1SYAwHB0Dq2AANIwoen7Lk220.jpg "title=" 8.png " alt= "Wkiom1syawhb0dq2aaniwoen7lk220.jpg"/>

• Server Configuration: Change service startup account to domain account Sqlservices, the startup type is changed to "Automatic", "Next"

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/57/54/wKioL1SYA7eh6THeAAOREGCgRJo461.jpg "title=" 9.png " alt= "Wkiol1sya7eh6theaaoregcgrjo461.jpg"/>

• Add the current user and SQLAdmins as the SQL Server administrator, "Next"

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/57/54/wKioL1SYA8LgE9MiAAOTJrrV8JQ229.jpg "title=" 10.png "alt=" Wkiol1sya8lge9miaaotjrrv8jq229.jpg "/>

• Go directly to the next step until you are ready to install the interface and click "Install".

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/57/57/wKiom1SYAyWRgEhiAAN6G8yYlyI918.jpg "title=" 11.png "alt=" Wkiom1syaywrgehiaan6g8yylyi918.jpg "/>

• wait SQL Server Installation

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/57/54/wKioL1SYA9mwh_szAAG_lN4Jw3w813.jpg "title=" 12.png "alt=" Wkiol1sya9mwh_szaag_ln4jw3w813.jpg "/>

• after a period of waiting, SQL Server has been successfully installed, such as:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/57/57/wKiom1SYAz2wX_cKAAPfGecz5Mc215.jpg "title=" 13.png "alt=" Wkiom1syaz2wx_ckaapfgecz5mc215.jpg "/>

• Open SQL Server2012 Management Studio, click "Connect" to verify that you can connect to SQL successfully

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/57/54/wKioL1SYA_Pj9egRAAEo_sX6BxA407.jpg "title=" 14.png "alt=" Wkiol1sya_pj9egraaeo_sx6bxa407.jpg "/>

• visible is the ability to successfully connect to SQL , such as:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/57/57/wKiom1SYA1eBRWnMAAIUx6z_u0E398.jpg "title=" 15.png "alt=" Wkiom1sya1ebrwnmaaiux6z_u0e398.jpg "/>

Note: The installation completes SQL Server Restart server is recommended after

3.  Open Firewall Rules

• we need to be open on the database server TCP 1433 (default instance with 1433 Port, custom instance with 1434 port) allows inbound rules, opens "Windows Firewall"-"Advanced Settings" ---inbound rules-new rule, select Port as:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/57/54/wKioL1SYBBOQx_R8AAGPTAFNEgM475.jpg "title=" 16.png "alt=" Wkiol1sybboqx_r8aagptafnegm475.jpg "/>

• Select TCP and enter a specific port number 1433, next

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/57/54/wKioL1SYBDuC6sFpAAFmqypngl0928.jpg "title=" 17.png "alt=" Wkiol1sybduc6sfpaafmqypngl0928.jpg "/>

• check "Allow connections"--- next

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/57/57/wKiom1SYA9vhwa9fAAHCqRYZfRQ058.jpg "title=" 18.png "alt=" Wkiom1sya9vhwa9faahcqryzfrq058.jpg "/>

• For security reasons, just tick "domain" and "next"

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/57/54/wKioL1SYBJLi66RvAAFg63ihl_w254.jpg "title=" 19.png "alt=" Wkiol1sybjli66rvaafg63ihl_w254.jpg "/>

• Enter the name of this rule and click "Done"

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/57/57/wKiom1SYA_biB22lAAE8FB5Cu8I109.jpg "title=" 20.png "alt=" Wkiom1sya_bib22laae8fb5cu8i109.jpg "/>

• When you are finished, you can see that a new rule has been added to the inbound rule, such as:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/57/54/wKioL1SYBK6gj6xMAAKfSn084kc404.jpg "title=" 21.png "alt=" Wkiol1sybk6gj6xmaakfsn084kc404.jpg "/>

• The telnet command (telnet192.168.1.11 1433) allows you to test whether the port is configured successfully, such as:

No information is returned to indicate that the port is pass-through.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/57/57/wKiom1SYBBeSXXvKAACOvNNZ3bo313.jpg "title=" 22.png "alt=" Wkiom1sybbesxxvkaacovnnz3bo313.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/57/54/wKioL1SYBMyz7cO9AABgtgClL0E285.jpg "title=" 23.png "alt=" Wkiol1sybmyz7co9aabgtgcll0e285.jpg "/>

so far we have completed the installation of the database, thank you for your attention. The next section will share the offline installation of SharePoint Server 2013 prerequisites.

This article from "Bright Future" blog, declined reprint!

SharePoint Server 2013 bis: Preparing the database