System Center R2 POC Deployment Database SQL2012 Deployment

System Center R2 POC Deployment Database SQL2012 Deployment

When deploying the database SQL2012, install SQL2012 to the disk (or partition) that the operating system thinks, and in this POC, add a virtual disk to the database server to install and store the SQL2012.

1. SQL database server increased disk

Double-click the open SQL database server----file---settings in Hyper-V

650) this.width=650; "title=" clip_image002 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image002 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303008OOI0.jpg "height="/>

Click SCSI controller------Hard Drive---add

650) this.width=650; "title=" clip_image004 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image004 "src=" http://img1.51cto.com/attachment/201407/25/212259_14063030089MOq.jpg "height=" 367 "/>

Click New

650) this.width=650; "title=" clip_image006 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image006 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303009GpqP.jpg "height=" 423 "/>

Click Next

650) this.width=650; "title=" clip_image008 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image008 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303009XUg2.jpg "height=" 481 "/>

Click on dynamic expansion ( preferably with a fixed-size virtual disk in your production environment, and better performance )

650) this.width=650; "title=" clip_image010 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image010 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303010SJKo.jpg "height=" 480 "/>

Enter the disk name and select the location where the disk is stored

650) this.width=650; "title=" clip_image012 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image012 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303011RWGj.jpg "height=" 481 "/>

Enter disk space size

650) this.width=650; "title=" clip_image014 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image014 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303011tlE3.jpg "height=" 484 "/>

Click Done.

650) this.width=650; "title=" clip_image016 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image016 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303012Aisu.jpg "height=" 482 "/>

Click Apply

650) this.width=650; "title=" clip_image018 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image018 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303012Xpz5.jpg "height=" 484 "/>

Open database Server Computer Management---Disk Management, right-click Disk---Online

650) this.width=650; "title=" clip_image020 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image020 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303013820h.jpg "height=" 353 "/>

Right-click Disk---Initialize Disk

650) this.width=650; "title=" clip_image022 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image022 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303013FnuB.jpg "height=" 348 "/>

Select disk and partition format

650) this.width=650; "title=" clip_image023 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image023 "src=" Http://img1.51cto.com/attachment/201407/25/212259_140630301437KH.png "height=" 484 "/>

Right-click Disk---new simple volume

650) this.width=650; "title=" clip_image025 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image025 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303015baH6.jpg "height=" 347 "/>

Click Next

650) this.width=650; "title=" clip_image027 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image027 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303015SmVs.jpg "height=" 484 "/>

Click Next

650) this.width=650; "title=" clip_image029 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image029 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303016aNSr.jpg "height=" 484 "/>

Assign a disk drive letter and click Next

650) this.width=650; "title=" clip_image031 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image031 "src=" http://img1.51cto.com/attachment/201407/25/212259_14063030162gvN.jpg "height=" 484 "/>

Select perform Quick format and click Next

650) this.width=650; "title=" clip_image033 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image033 "src=" http://img1.51cto.com/attachment/201407/25/212259_14063030174cfc.jpg "height=" 484 "/>

Click Done.

650) this.width=650; "title=" clip_image035 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image035 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303017DEVe.jpg "height=" 484 "/>

2. Add. Net 3.5

Open Server Manager---Dashboards---add roles and Features

650) this.width=650; "title=" clip_image037 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image037 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303018wm6V.jpg "height=" 262 "/>

Click Next

650) this.width=650; "title=" clip_image039 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image039 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303018abFL.jpg "height=" 458 "/>

Click Next

650) this.width=650; "title=" clip_image041 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image041 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303019l2vF.jpg "height=" 454 "/>

Select Server and click Next

650) this.width=650; "title=" clip_image043 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image043 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303019ykCE.jpg "height=" 456 "/>

Click Next

650) this.width=650; "title=" clip_image045 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image045 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303020oMJ4.jpg "height=" 451 "/>

Select the. NET Framework 3.5

650) this.width=650; "title=" clip_image047 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image047 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303020Rbrk.jpg "height=" 447 "/>

To add a specified alternate path

650) this.width=650; "title=" clip_image049 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image049 "src=" http://img1.51cto.com/attachment/201407/25/212259_14063030217obV.jpg "height=" 444 "/>

Click Install

650) this.width=650; "title=" clip_image051 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image051 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303021daQT.jpg "height=" 445 "/>

650) this.width=650; "title=" clip_image053 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image053 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303022s1n3.jpg "height=" 453 "/>

. NET 3.5 Installation Complete

3. Install SQL SP1

Run the SQL Setup program

650) this.width=650; "title=" clip_image054 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image054 "src=" Http://img1.51cto.com/attachment/201407/25/212259_1406303023hZi8.png "height=" 352 "/>

Click Install

650) this.width=650; "title=" clip_image056 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image056 "src=" http://img1.51cto.com/attachment/201407/25/212259_14063030231KZ8.jpg "height=" 482 "/>

Click the new SQL Server standalone installation or add features to an existing installation

650) this.width=650; "title=" clip_image058 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image058 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303024ERva.jpg "height=" 302 "/>

Click OK

650) this.width=650; "title=" clip_image060 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image060 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303025l5Fk.jpg "height=" 480 "/>

650) this.width=650; "title=" clip_image061 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image061 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303025ZXvM.png "height="/>

Click Next

650) this.width=650; "title=" clip_image063 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image063 "src=" http://img1.51cto.com/attachment/201407/25/212259_14063030257cd8.jpg "height=" 484 "/>

Accept the license agreement and click Next

650) this.width=650; "title=" clip_image065 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image065 "src=" http://img1.51cto.com/attachment/201407/25/212259_14063030265nZR.jpg "height=" 479 "/>

Install product updates, do not install, click Next

650) this.width=650; "title=" clip_image067 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image067 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303027wscc.jpg "height=" 483 "/>

Click Next

650) this.width=650; "title=" clip_image069 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image069 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303027t3GW.jpg "height=" 481 "/>

Select the SQL Server feature installation and click Next

650) this.width=650; "title=" clip_image071 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image071 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303028uCSN.jpg "height=" 480 "/>

Select the features you want to install

650) this.width=650; "title=" clip_image073 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image073 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303028hJpi.jpg "height=" 476 "/>

Select features to install, modify the shared features directory

650) this.width=650; "title=" clip_image075 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image075 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303029ms7X.jpg "height=" 333 "/>

Click Next

650) this.width=650; "title=" clip_image077 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image077 "src=" http://img1.51cto.com/attachment/201407/25/212259_14063030306alL.jpg "height=" 481 "/>

Select the default instance, modify the installation directory to E Drive, and click Next

650) this.width=650; "title=" clip_image079 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image079 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303030pvKp.jpg "height=" 484 "/>

650) this.width=650; "title=" clip_image080 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image080 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303031Jge9.jpg "height=" 484 "/>

Click Next

650) this.width=650; "title=" clip_image082 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image082 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303031DQL6.jpg "height=" 483 "/>

Click Sort Rules

650) this.width=650; "title=" clip_image084 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image084 "src=" http://img1.51cto.com/attachment/201407/25/212259_14063030328ywQ.jpg "height=" 390 "/>

Modify collation to Sql_latin1_general_cp1_ci_ai (scom requires collation)

650) this.width=650; "title=" clip_image086 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image086 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303032JjvW.jpg "height=" 484 "/>

650) this.width=650; "title=" clip_image088 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image088 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303033YR9l.jpg "height=" 184 "/>

Click Next

, 650) this.width=650; "title=" clip_image090 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image090 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303033c2ol.jpg "height=" 478 "/>

Select mixed Mode, set the SA password, and select Add current user as Administrator, click Next

650) this.width=650; "title=" clip_image092 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image092 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303034l1pN.jpg "height=" 484 "/>

650) this.width=650; "title=" clip_image094 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image094 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303035obIT.jpg "height=" 480 "/>

Select Install and configure, and click Next

650) this.width=650; "title=" clip_image096 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image096 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303035TYyj.jpg "height=" 483 "/>

Click Next

650) this.width=650; "title=" clip_image098 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image098 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303036o6oi.jpg "height=" 481 "/>

Click Next

650) this.width=650; "title=" clip_image100 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image100 "src=" http://img1.51cto.com/attachment/201407/25/212259_14063030365Tsz.jpg "height=" 483 "/>

Click Install

650) this.width=650; "title=" clip_image102 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image102 "src=" http://img1.51cto.com/attachment/201407/25/212259_1406303037fi7S.jpg "height=" 479 "/>

650) this.width=650; "title=" clip_image104 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image104 "src=" http://img1.51cto.com/attachment/201407/25/212259_14063030385JJW.jpg "height=" 484 "/>

At this point, the SQL 2012 installation is complete.

This article is from the "zeroing" blog, so be sure to keep this source http://fjcloud.blog.51cto.com/212259/1530295