SCCM One of R2 Combat series: SQL Installation

Hello everyone, starting today with everyone to share their own learning SCCM R2 Some of the experience and specific deployment configuration, I hope to help everyone. As the steps for SCCM deployment are more complex and more content, I have divided the entire SCCM deployment process into the following three chapters:

• Installation of SQL Server SP1

L SCCM Pre-installation preparations

• Deployment of the SCCM primary site

1.1 Experimental topology diagram:

Here is a topology diagram of this deployment, with all operating systems using the Windows Server R2 Datacenter version

650) this.width=650; "title=" clip_image003 "style=" Border-top:0px;border-right:0px;border-bottom:0px;border-left : 0px; "border=" 0 "alt=" clip_image003 "src=" Http://img1.51cto.com/attachment/201407/24/8959108_1406211032BNMb.png " height= "587"/>

1.2 Preparing for a domain environment

Many of Microsoft's products are domain-based, and we need to deploy the domain environment before we start deploying SCCM, and the domain environment is not prepared here, the following steps are outlined below

650) this.width=650; "title=" clip_image001 "style=" Border-top:0px;border-right:0px;border-bottom:0px;border-left : 0px; "border=" 0 "alt=" clip_image001 "src=" Http://img1.51cto.com/attachment/201407/24/8959108_1406211033Nnbf.gif " Height= "/>" Installs Active Directory Domain Services on 12ser2 and prompts the computer 12ser2 as a domain controller (ilync.cn)

650) this.width=650; "title=" clip_image001[1] "style=" border-top:0px;border-right:0px;border-bottom:0px; border-left:0px; "border=" 0 "alt=" clip_image001[1] "src=" http://img1.51cto.com/attachment/201407/24/8959108_ 1406211033uk5j.gif "height="/> Adding computers 12ser3 and 12ser4 to the domain

1.3 SQL Server SP1 Deployment (12ser3/10.0.0.30) 1.3.1 Create a SQL service startup account Sqladmin

Create a domain user sqladmin on the domain controller and add sqladmin to the Domain Admin group for the login account of the SQL service. (It is strongly not recommended to use the Administrator account as the login account for SQL service, because the administrator account is required to change the password periodically, the SQL Server service will not start properly after the password modification)

650) this.width=650; "title=" clip_image001[2] "style=" border-top:0px;border-right:0px;border-bottom:0px; border-left:0px; "border=" 0 "alt=" clip_image001[2] "src=" http://img1.51cto.com/attachment/201407/24/8959108_ 1406211033wces.gif "height="/> Open active Directory users and Computers----New user-----Enter the relevant information and click Next, such as:

650) this.width=650; "title=" clip_image004 "style=" Border-top:0px;border-right:0px;border-bottom:0px;border-left : 0px; "border=" 0 "alt=" clip_image004 "src=" Http://img1.51cto.com/attachment/201407/24/8959108_1406211034HQ2H.png " height= "576"/>

650) this.width=650; "title=" clip_image001[3] "style=" border-top:0px;border-right:0px;border-bottom:0px; border-left:0px; "border=" 0 "alt=" clip_image001[3] "src=" http://img1.51cto.com/attachment/201407/24/8959108_ 1406211035dwdn.gif "height="/> Enter the password-----tick---The next----complete

650) this.width=650; "title=" clip_image006 "style=" Border-top:0px;border-right:0px;border-bottom:0px;border-left : 0px; "border=" 0 "hspace=" alt= "clip_image006" src= "http://img1.51cto.com/attachment/201407/24/8959108_ 1406211038mbul.jpg "height=" 333 "/>

650) this.width=650; "title=" clip_image001[4] "style=" border-top:0px;border-right:0px;border-bottom:0px; border-left:0px; "border=" 0 "alt=" clip_image001[4] "src=" http://img1.51cto.com/attachment/201407/24/8959108_ 1406211038kaaj.gif "height="/> The user sqladmin join the group Domain Admin, this operation is also relatively simple.

1.3.2 Installing SQL Server SP1

650) this.width=650; "title=" clip_image001[5] "style=" border-top:0px;border-right:0px;border-bottom:0px; border-left:0px; "border=" 0 "alt=" clip_image001[5] "src=" http://img1.51cto.com/attachment/201407/24/8959108_ 1406211039cqqh.gif "height="/> Installing the. NET Framework 3.5

650) this.width=650; "title=" clip_image001[6] "style=" border-top:0px;border-right:0px;border-bottom:0px; border-left:0px; "border=" 0 "alt=" clip_image001[6] "src=" http://img1.51cto.com/attachment/201407/24/8959108_ 14062110398goe.gif "height="/> Insert the SQL Server2012 SP1 disc, click "Install" on the left and select "New SQL Server standalone installation or add features to an existing installation":

650) this.width=650; "title=" clip_image007 "style=" Border-top:0px;border-right:0px;border-bottom:0px;border-left : 0px; "border=" 0 "alt=" clip_image007 "src=" Http://img1.51cto.com/attachment/201407/24/8959108_14062110405pLk.png " height= "602"/>

650) this.width=650; "title=" clip_image001[7] "style=" border-top:0px;border-right:0px;border-bottom:0px; border-left:0px; "border=" 0 "alt=" clip_image001[7] "src=" http://img1.51cto.com/attachment/201407/24/8959108_ 1406211041jsak.gif "height="/> To install the program support rules check, the status is passed, click OK,

650) this.width=650; "title=" clip_image008 "style=" Border-top:0px;border-right:0px;border-bottom:0px;border-left : 0px; "border=" 0 "alt=" clip_image008 "src=" Http://img1.51cto.com/attachment/201407/24/8959108_1406211043cIpM.png " height= "618"/>

650) this.width=650; "title=" clip_image001[8] "style=" border-top:0px;border-right:0px;border-bottom:0px; border-left:0px; "border=" 0 "alt=" clip_image001[8] "src=" http://img1.51cto.com/attachment/201407/24/8959108_ 1406211043lhf8.gif "height="/> Enter the product key----next,

650) this.width=650; "title=" clip_image009 "style=" Border-top:0px;border-right:0px;border-bottom:0px;border-left : 0px; "border=" 0 "alt=" clip_image009 "src=" Http://img1.51cto.com/attachment/201407/24/8959108_1406211046ltYM.png " height= "615"/>

650) this.width=650; "title=" clip_image001[9] "style=" border-top:0px;border-right:0px;border-bottom:0px; border-left:0px; "border=" 0 "alt=" clip_image001[9] "src=" http://img1.51cto.com/attachment/201407/24/8959108_ 1406211046pag6.gif "height="/> Check "I accept the license terms"

650) this.width=650; "title=" clip_image010 "style=" Border-top:0px;border-right:0px;border-bottom:0px;border-left : 0px; "border=" 0 "alt=" clip_image010 "src=" Http://img1.51cto.com/attachment/201407/24/8959108_1406211048YRqm.png " height= "619"/>

650) this.width=650; "title=" clip_image001[10] "style=" border-top:0px;border-right:0px;border-bottom:0px; border-left:0px; "border=" 0 "alt=" clip_image001[10] "src=" http://img1.51cto.com/attachment/201407/24/8959108_ 1406211048ivic.gif "height=" "/>" in the product update, according to the needs of the actual environment, my environment is not connected to the public network will not check the update---next---Click Install

650) this.width=650; "title=" clip_image011 "style=" Border-top:0px;border-right:0px;border-bottom:0px;border-left : 0px; "border=" 0 "alt=" clip_image011 "src=" Http://img1.51cto.com/attachment/201407/24/8959108_1406211049h0qz.png " height= "618"/>

650) this.width=650; "title=" clip_image001[11] "style=" border-top:0px;border-right:0px;border-bottom:0px; border-left:0px; "border=" 0 "alt=" clip_image001[11] "src=" http://img1.51cto.com/attachment/201407/24/8959108_ 1406211049duq7.gif "height="/> Warning is due to my environment is not connected to the cause, can be ignored, click Next

650) this.width=650; "title=" clip_image012 "style=" Border-top:0px;border-right:0px;border-bottom:0px;border-left : 0px; "border=" 0 "alt=" clip_image012 "src=" Http://img1.51cto.com/attachment/201407/24/8959108_1406211050sGYY.png " height= "618"/>

650) this.width=650; "title=" clip_image001[12] "style=" border-top:0px;border-right:0px;border-bottom:0px; border-left:0px; "border=" 0 "alt=" clip_image001[12] "src=" http://img1.51cto.com/attachment/201407/24/8959108_ 1406211051p33e.gif "height="/> directly next to the "Feature Selection" interface, select the following features and specify the function directory----Next,

650) this.width=650; "title=" clip_image013 "style=" Border-top:0px;border-right:0px;border-bottom:0px;border-left : 0px; "border=" 0 "alt=" clip_image013 "src=" Http://img1.51cto.com/attachment/201407/24/8959108_1406211052vtCD.png " height= "734"/>

650) this.width=650; "title=" clip_image001[13] "style=" border-top:0px;border-right:0px;border-bottom:0px; border-left:0px; "border=" 0 "alt=" clip_image001[13] "src=" http://img1.51cto.com/attachment/201407/24/8959108_ 1406211055gfxl.gif "height="/> Check installation rules, status is passed, next

650) this.width=650; "title=" clip_image014 "style=" Border-top:0px;border-right:0px;border-bottom:0px;border-left : 0px; "border=" 0 "alt=" clip_image014 "src=" Http://img1.51cto.com/attachment/201407/24/8959108_14062110570G8X.png " height= "619"/>

650) this.width=650; "title=" clip_image001[14] "style=" border-top:0px;border-right:0px;border-bottom:0px; border-left:0px; "border=" 0 "alt=" clip_image001[14] "src=" http://img1.51cto.com/attachment/201407/24/8959108_ 1406211057jbsn.gif "height="/> instance configuration, here I use the default instance

650) this.width=650; "title=" clip_image015 "style=" Border-top:0px;border-right:0px;border-bottom:0px;border-left : 0px; "border=" 0 "alt=" clip_image015 "src=" Http://img1.51cto.com/attachment/201407/24/8959108_1406211058MvY7.png " height= "618"/>

650) this.width=650; "title=" clip_image001[15] "style=" border-top:0px;border-right:0px;border-bottom:0px; border-left:0px; "border=" 0 "alt=" clip_image001[15] "src=" http://img1.51cto.com/attachment/201407/24/8959108_ 1406211059gauv.gif "height="/> Set up the service account as a domain account and set the startup mode to Automatic, where we are all set to account Sqladmin,

650) this.width=650; "title=" clip_image016 "style=" Border-top:0px;border-right:0px;border-bottom:0px;border-left : 0px; "border=" 0 "alt=" clip_image016 "src=" Http://img1.51cto.com/attachment/201407/24/8959108_14062110608H48.png " height= "617"/>

650) this.width=650; "title=" clip_image001[16] "style=" border-top:0px;border-right:0px;border-bottom:0px; border-left:0px; "border=" 0 "alt=" clip_image001[16] "src=" http://img1.51cto.com/attachment/201407/24/8959108_ 1406211060qtcm.gif "height="/> Switch to the Collation tab, click "Customize", select SQL collation for backwards compatibility, and specify "SQL_Latin1_General_CP1_CI_AS", click "OK , return to the collation, and then tap Next:

Note: It is important here that if you do not change the collation, the post-installation SCCM will fail!

650) this.width=650; "title=" clip_image017 "style=" Border-top:0px;border-right:0px;border-bottom:0px;border-left : 0px; "border=" 0 "alt=" clip_image017 "src=" Http://img1.51cto.com/attachment/201407/24/8959108_140621106338sR.png " height= "624"/>

650) this.width=650; "title=" clip_image001[17] "style=" border-top:0px;border-right:0px;border-bottom:0px; border-left:0px; "border=" 0 "alt=" clip_image001[17] "src=" http://img1.51cto.com/attachment/201407/24/8959108_ 1406211063jr0y.gif "height="/> Add SQL Server Administrator (Ilync\administrator, ilync\sqladmin), all of the following use the default configuration, Next----Next---next----install

650) this.width=650; "title=" clip_image018 "style=" Border-top:0px;border-right:0px;border-bottom:0px;border-left : 0px; "border=" 0 "alt=" clip_image018 "src=" Http://img1.51cto.com/attachment/201407/24/8959108_1406211064isUY.png " height= "617"/>

650) this.width=650; "title=" clip_image001[18] "style=" border-top:0px;border-right:0px;border-bottom:0px; border-left:0px; "border=" 0 "alt=" clip_image001[18] "src=" http://img1.51cto.com/attachment/201407/24/8959108_ 1406211064ghjg.gif "height="/> SQL Server SP1 installation succeeded,
650) this.width=650; "title=" clip_image019 "style=" Border-top:0px;border-right:0px;border-bottom:0px;border-left : 0px; "border=" 0 "alt=" clip_image019 "src=" Http://img1.51cto.com/attachment/201407/24/8959108_14062110667HN2.png " height= "640"/>

1.3.3 Adjusting SQL Memory settings

In the prerequisite check for installing SCCM R2, the memory configuration of SQL is automatically checked. Requires a minimum of 8G for the central site and primary site, and a minimum of 4G for the secondary site.

650) this.width=650; "title=" clip_image020 "style=" Border-top:0px;border-right:0px;border-bottom:0px;border-left : 0px; "border=" 0 "alt=" clip_image020 "src=" Http://img1.51cto.com/attachment/201407/24/8959108_14062110676lB9.png " height= "659"/>

To this, the installation of SQL Server SP1 has been completed. The next chapter will share with you the preparation for SCCM before installation.

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