SQL Server preparation prior to SCCM deployment

SQL Server preparation prior to SCCM deployment

As we said earlier, the deployment of SCCM requires support for SQL Server databases. Because we are a real-time, SCCM blog post, we deploy our database products separately on the server. If your friends are ready to evaluate the product, you can also deploy SQL database and SCCM on the same test machine.

In addition to supporting SCCM, the SQL Server database can also support WSUS. Our WSUS is installed on the SCCM server and uses the SQL database in this live series blog. WSUS needs to use the SQL database to store updated meta-files, and if SQL Server is installed on the SCCM servers, there is no additional Windows Internal database installed for WSUS.

The background database for SCCM TP4 can be SQL Server SP1 or SQL Server 2014. Deploying SCCM's backend database SQL Server is not as simple as it might seem. SCCM has certain requirements for version and collation in SQL Server, and it is not easy for next to complete the deployment. The procedures for deploying SQL Server SP1 are described below.

The deployment of SQL Server SP1 requires the support of the. NET Framework 3.5, and if you do not install the. NET Framework 3.5 during the installation of SQL, you will be shown how to install the. NET Framework 3.5. The steps are as follows:

Open Server Manager, click "Add Roles and Features" and click Next:

650) this.width=650; "Width=" 457 "height=" 344 "title=" clip_image002 "style=" padding-top:0px;padding-right:0px; Padding-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;background-image:none; " alt= "clip_image002" src= "http://s3.51cto.com/wyfs02/M02/7F/D6/wKioL1cv9h-iD3pHAABzwQMBXAg891.jpg" border= "0"/ >

In the Select Server function location check the. Net Framework 3.5, click Next:

650) this.width=650; "Width=" 458 "height=" 344 "title=" clip_image004 "style=" padding-top:0px;padding-right:0px; Padding-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;background-image:none; " alt= "clip_image004" src= "http://s3.51cto.com/wyfs02/M00/7F/D6/wKioL1cv9iGhP3C5AACHr3qmFZg028.jpg" border= "0"/ >

To specify an alternate source path, click OK:

650) this.width=650; "Width=" 457 "height=" 344 "title=" clip_image006 "style=" padding-top:0px;padding-right:0px; Padding-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;background-image:none; " alt= "clip_image006" src= "http://s3.51cto.com/wyfs02/M00/7F/D9/wKiom1cv9UbRhqx3AAC3TvrTlek049.jpg" border= "0"/ >

Click Install:

650) this.width=650; "Width=" 457 "height=" 344 "title=" clip_image008 "style=" padding-top:0px;padding-right:0px; Padding-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;background-image:none; " alt= "clip_image008" src= "http://s3.51cto.com/wyfs02/M00/7F/D7/wKioL1cv93igJmzlAAB4lzGEJjE244.jpg" border= "0"/ >

When the installation is complete, click Close:

650) this.width=650; "Width=" 458 "height=" 344 "title=" clip_image010 "style=" padding-top:0px;padding-right:0px; Padding-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;background-image:none; " alt= "clip_image010" src= "http://s3.51cto.com/wyfs02/M01/7F/D9/wKiom1cv9p2zteZcAABiShWvOmY877.jpg" border= "0"/ >

After the installation is complete, insert the. Net Framework 3.5 into the CD-ROM drive after the SQL Server SP1 installation CD and choose to run the installation from media, and then select Install-New installation or add features to an existing installation as follows:

650) this.width=650; "Width=" 458 "height=" 344 "title=" clip_image012 "style=" padding-top:0px;padding-right:0px; Padding-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;background-image:none; " alt= "clip_image012" src= "http://s3.51cto.com/wyfs02/M02/7F/D9/wKiom1cv9p7jH3ooAACZOUdIYqA210.jpg" border= "0"/ >

"Setup support Rules" Check by, click "OK":

650) this.width=650; "Width=" 557 "height=" 419 "title=" clip_image014 "style=" padding-top:0px;padding-right:0px; Padding-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;background-image:none; " alt= "clip_image014" src= "http://s3.51cto.com/wyfs02/M00/7F/D9/wKiom1cv9p-j9KgnAACU0topHMU598.jpg" border= "0"/ >

Enter the product key and click Next:

650) this.width=650; "Width=" 557 "height=" 419 "title=" clip_image016 "style=" padding-top:0px;padding-right:0px; Padding-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;background-image:none; " alt= "clip_image016" src= "http://s3.51cto.com/wyfs02/M02/7F/D7/wKioL1cv93yyIuQrAACnloSgZWw609.jpg" border= "0"/ >

To accept the license terms, click Next:

650) this.width=650; "Width=" 557 "height=" 419 "title=" clip_image018 "style=" padding-top:0px;padding-right:0px; Padding-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;background-image:none; " alt= "clip_image018" src= "http://s3.51cto.com/wyfs02/M00/7F/D7/wKioL1cv937yiyHkAADVofbhx20179.jpg" border= "0"/ >

The system "Installer support rule check" is here to click Next:

650) this.width=650; "Width=" 557 "height=" 419 "title=" clip_image020 "style=" padding-top:0px;padding-right:0px; Padding-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;background-image:none; " alt= "clip_image020" src= "http://s3.51cto.com/wyfs02/M00/7F/D7/wKioL1cv93_Bdm4LAADbf9IBFbk855.jpg" border= "0"/ >

Select "SQL Server feature Installation (S)" Here and click Next:

650) this.width=650; "Width=" 557 "height=" 419 "title=" clip_image022 "style=" padding-top:0px;padding-right:0px; Padding-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;background-image:none; " alt= "clip_image022" src= "http://s3.51cto.com/wyfs02/M01/7F/D7/wKioL1cv94HTZXnuAADAfPQUMjo379.jpg" border= "0"/ >

Tick the desired function (specific function) and click Next:

650) this.width=650; "Width=" 557 "height=" 419 "title=" clip_image024 "style=" padding-top:0px;padding-right:0px; Padding-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;background-image:none; " alt= "clip_image024" src= "http://s3.51cto.com/wyfs02/M02/7F/D9/wKiom1cv9qaxhzkuAAEA0wUb8Ks183.jpg" border= "0"/ >

650) this.width=650; "Width=" 457 "height=" 344 "title=" clip_image026 "style=" padding-top:0px;padding-right:0px; Padding-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;background-image:none; " alt= "clip_image026" src= "http://s3.51cto.com/wyfs02/M02/7F/D9/wKiom1cv9qeizDZNAACpoNJzn_Y322.jpg" border= "0"/ >

Install the rule check pass and click Next:

650) this.width=650; "Width=" 557 "height=" 419 "title=" clip_image028 "style=" padding-top:0px;padding-right:0px; Padding-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;background-image:none; " alt= "clip_image028" src= "http://s3.51cto.com/wyfs02/M00/7F/D7/wKioL1cv94Xi6KTZAACpAZrupFg969.jpg" border= "0"/ >

Select default instance at instance configuration and click Next:

650) this.width=650; "Width=" 557 "height=" 419 "title=" clip_image030 "style=" padding-top:0px;padding-right:0px; Padding-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;background-image:none; " alt= "clip_image030" src= "Http://s3.51cto.com/wyfs02/M00/7F/D9/wKiom1cv9qrBWgXGAADQL Q_Q 58c374.jpg" border= "0"/ >

Set the SQL Server service startup account: The default startup type for SQL Server Agent service is manual and needs to be modified to automatic. Then specify the service account for SQL, because the permission minimization principle is required in the production environment, so I use Sqladmin as the service startup account. After the startup account setting is complete, to switch to the collation in, the collation setting is important.

650) this.width=650; "Width=" 557 "height=" 419 "title=" clip_image032 "style=" padding-top:0px;padding-right:0px; Padding-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;background-image:none; " alt= "clip_image032" src= "http://s3.51cto.com/wyfs02/M01/7F/D7/wKioL1cv94iDBS3nAADavmtylTU012.jpg" border= "0"/ >

Click Collation to change the collation to Latin sort: SQL_Latin1_General_CP1_CI_AS backwards compatible:

650) this.width=650; "Width=" 557 "height=" 419 "title=" clip_image034 "style=" padding-top:0px;padding-right:0px; Padding-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;background-image:none; " alt= "clip_image034" src= "http://s3.51cto.com/wyfs02/M02/7F/D9/wKiom1cv9q2RdH0hAAC0CPEuVIE309.jpg" border= "0"/ >

At database engine configuration, specify the authentication mode for mixed authentication mode and enter the password and then specify the SQL Server Administrator account:

650) this.width=650; "Width=" 557 "height=" 419 "title=" clip_image036 "style=" padding-top:0px;padding-right:0px; Padding-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;background-image:none; " alt= "clip_image036" src= "http://s3.51cto.com/wyfs02/M00/7F/D9/wKiom1cv9q_jMvddAADsl8gD9A8033.jpg" border= "0"/ >

Click "Install" when you are ready to confirm the installation location:

650) this.width=650; "Width=" 557 "height=" 419 "title=" clip_image038 "style=" padding-top:0px;padding-right:0px; Padding-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;background-image:none; " alt= "clip_image038" src= "http://s3.51cto.com/wyfs02/M00/7F/D7/wKioL1cv94zDvi48AADMsPzZE3I463.jpg" border= "0"/ >

When the installation is complete, click Close:

650) this.width=650; "Width=" 557 "height=" 419 "title=" clip_image040 "style=" padding-top:0px;padding-right:0px; Padding-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;background-image:none; " alt= "clip_image040" src= "http://s3.51cto.com/wyfs02/M01/7F/D7/wKioL1cv946w-Z6dAADyg49FXpg146.jpg" border= "0"/ >

After you install SQL Server, you will need to add the SCCM computer account to the local Administrators group of the SQL Server to give it Full Control permissions:

650) this.width=650; "Width=" 482 "height=" 590 "title=" clip_image041 "style=" padding-top:0px;padding-right:0px; Padding-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;background-image:none; " alt= "clip_image041" src= "http://s3.51cto.com/wyfs02/M02/7F/D7/wKioL1cv-_LwnVFmAAHCUfFH0TI997.png" border= "0"/ >

OK, for the installation of SQL Server we will introduce you so much today!

This article is from the "Wu Yuzhang Microsoft blog" blog, make sure to keep this source http://wuyvzhang.blog.51cto.com/9992636/1771387

SQL Server preparation prior to SCCM deployment