SCCM R2 SQL Preparation
System Preparation
Installing the net Framework 3.5
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/53/8B/wKiom1RqvRGylMiVAAF21FhZulo205.jpg "title=" NET 3.5 "alt=" Wkiom1rqvrgylmivaaf21fhzulo205.jpg "/>
2. Installing SQL Server
Click Install Media setup.exe, select Install
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/53/89/wKioL1RqvZ7DtVyVAALF5Ngf_x4318.jpg "title=" 02.png "alt=" Wkiol1rqvz7dtvyvaalf5ngf_x4318.jpg "/>
Click on the new SQL SERVER Standalone installation or adding functionality to an existing installation
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/53/89/wKioL1RqvbOieJtvAANSqU7pfZU559.jpg "title=" 03.png "alt=" Wkiol1rqvboiejtvaansqu7pfzu559.jpg "/>
Click to confirm
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/53/89/wKioL1RqvcODHuEwAAJp0SJPlU0626.jpg "title=" 04.png "alt=" Wkiol1rqvcodhuewaajp0sjplu0626.jpg "/>
Click Next
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/53/89/wKioL1RqvdSArBfgAAMACyGL-Bg193.jpg "title=" 05.png "alt=" Wkiol1rqvdsarbfgaamacygl-bg193.jpg "/>
Click I accept the license terms and click Next
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/53/8B/wKiom1RqvWvT4dGUAAIjXzMfxz0180.jpg "title=" 06.png "alt=" Wkiom1rqvwvt4dguaaijxzmfxz0180.jpg "/>
Click Next
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/53/8B/wKiom1RqvXnDOQNfAANBayu02es307.jpg "title=" 07.png "alt=" Wkiom1rqvxndoqnfaanbayu02es307.jpg "/>
Click Next
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/53/8B/wKiom1RqvYWyRyEXAAIpyYLNyeg294.jpg "title=" 08.png "alt=" Wkiom1rqvywyryexaaipyylnyeg294.jpg "/>
Click Next to add the Database engine service, Report Services native, Administrative tools, and administrative Tools documentation
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/53/8B/wKiom1RqvY-zZeVPAAQUWwU1HKc017.jpg "title=" 09.png "alt=" Wkiom1rqvy-zzevpaaquwwu1hkc017.jpg "/>
Click Next
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/53/89/wKioL1RqvhjCm-xyAALbgyJZFUs144.jpg "title=" 10.png "alt=" Wkiol1rqvhjcm-xyaalbgyjzfus144.jpg "/>
Click Next
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/53/8B/wKiom1Rqva6wAHhOAAIxVRwwxN0644.jpg "title=" 11.png "alt=" Wkiom1rqva6wahhoaaixvrwwxn0644.jpg "/>
Click Next
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/53/89/wKioL1Rqvi7w0Zf8AANYpCvxfVU038.jpg "title=" 12.png "alt=" Wkiol1rqvi7w0zf8aanypcvxfvu038.jpg "/>
Click Next
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/53/8B/wKiom1Rqvl6T03YPAAJg3Utmsnk134.jpg "title=" 13.png "alt=" wkiom1rqvl6t03ypaajg3utmsnk134.jpg "/> Click Next, configure the data Inventory Engine service account, select the domain account
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/53/89/wKioL1RqvvfyQYdiAALZ5jp7yWM133.jpg "title=" 14.png "alt=" wkiol1rqvvfyqydiaalz5jp7ywm133.jpg "/> Select Collation sql_latin1_general_cp1_ci_as
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/53/8B/wKiom1RqvrWTVy-MAAKGN1kj_d0586.jpg "title=" 15.png "alt=" wkiom1rqvrwtvy-maakgn1kj_d0586.jpg "/> Click Next, click Add Current admin
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/53/89/wKioL1Rqv4_RHZbpAANjNpKgzS8835.jpg "title=" 16.png "alt=" Wkiol1rqv4_rhzbpaanjnpkgzs8835.jpg "/>
Click Next to Install and configure reportingservices native mode
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/53/89/wKioL1Rqv_DTdl9yAAMoIGzxpIM855.jpg "title=" 17.png "alt=" Wkiol1rqv_dtdl9yaamoigzxpim855.jpg "/>
Click Next
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/53/89/wKioL1RqwGLxQjgoAAMq3MBRSgI793.jpg "title=" 18.png "alt=" wkiol1rqwglxqjgoaamq3mbrsgi793.jpg "/> Click Next
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/53/89/wKioL1RqwH7QYpwaAAJITUNBbcw102.jpg "title=" 19.png "alt=" wkiol1rqwh7qypwaaajitunbbcw102.jpg "/> Click Next
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/53/8B/wKiom1RqwEqyXjxKAAMkYWTTFOY269.jpg "title=" 20.png "alt=" wkiom1rqweqyxjxkaamkywttfoy269.jpg "/> Click Install, wait for installation to complete
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/53/8B/wKiom1RqwGTgoei7AAPkAq_dExE979.jpg "title=" 21.png "alt=" Wkiom1rqwgtgoei7aapkaq_dexe979.jpg "/> 3. Simple Configuration SQL Server Service
SCCM memory needs at least 12GB, if not, there will be a corresponding warning, ignore can
Using SQL Server Management studio to connect to SQL Server, left-click on the server-Properties--memory, adjust minimum and maximum memory
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/53/89/wKioL1RqwQOgXH4KAAI4nClucmo799.jpg "title=" 22.png "alt=" Wkiol1rqwqogxh4kaai4nclucmo799.jpg "/>
This article is from "Tian Fan" blog, please be sure to keep this source http://ordinary.blog.51cto.com/212245/1578842
SCCM R2 SQL Preparation