Installing and Configuring System Center Configuration Manager (SCCM)

0%

0/1 Lessons

Getting Started with this Course

• 26min

0 / 3 lessons complete

System Center Configuration Manager - Features and Capibilities

• 31min

0 / 5 lessons complete

SCCM 1902 Lab Setup

• 50min

0 / 12 lessons complete

Installing SCCM 1902 Installation

• 1hr 17min

0 / 11 lessons complete

Configuration Manager Basics

• 1hr 53min

0 / 8 lessons complete

Updating SCCM

• 30min

0 / 7 lessons complete

SCCM Client Installation

• 46min

0 / 4 lessons complete

User and Device Collections

• 1hr 0min

0 / 13 lessons complete

Application Management

• 2hr 34min

0 / 12 lessons complete

Operating System Deployment

• 23min

0 / 7 lessons complete

Endpoint Protection

• 1hr 12min

0 / 10 lessons complete

Troubleshooting

• 37min

0 / 4 lessons complete

Problems and Solutions from the Message Board

• 14min

0 / 5 lessons complete

You need to sign up to get access!

Sign up to get full access to this course.

Sign up to access this lesson

Click here to sign up and get access to this lesson!

Saving Progress...

Install SQL Server 2017

In our lab we are going to install SQL Server 2017 Cumulative Update 2. Feel free to use an update newer than CU2, but that is the minimum you must install in order for it to be compatible with SCCM. Below is a table that you may reference for a list of supported versions of SCCM 1902 and SQL: 

SQL ServerEditionMin Cumulative Update
SQL Server 2017Standard, EnterpriseCU2
SQL Server 2016 SP1, SP2Standard, EnterpriseNot CU Required
SQL Server 2016Standard, EnterpriseNot CU Required
SQL Server 2014 SP1,SP2,SP3Standard, EnterpriseNo CU Required

You should have already downloaded the SQL Server 2017 executable, so at this point launch the installation file. 

This will prompt us to extract the installation files. I am going to place them on the C:\ drive.

Also, keep in mind that we will need to immediately update to cumulative update 2, so you may begin that download now while you wait from https://catalog.update.microsoft.com (search SQL 2017 Cumulative Update 2) if you have not downloaded it already. Please keep in mind for lab users this is pre-downloaded to the lab VM.

Once the SQL Server Installation Center opens, click New SQL Server stand-alone installation text:

If you have a product key, you may enter it now or choose to use the free evaluation edition and click Next. Agree to the license terms and click Next again. On the Microsoft Update page, click the checkbox next to Use Microsoft Update to check for updates, and click Next:

There will be a prerequisite check completed and you may see a warning about the Windows Firewall, this is ok and is generated when you have the Windows Firewall enabled (as it should be).

Click Next. Check the Database Engine Services checkbox and If you are installing a version older than SQL Server 2017, select the Reporting Services - Native checkbox as shown below:

In version 2017+, SQL Server Reporting Services can only be installed through a separate installer file which we will install later on. For now, check the Database Engine Services checkbox and click the Download it from the web link to being the Reporting Services installer download.

Important: If you’re using the ServerAcademy.com lab, we have already downloaded the installer file and placed it on the SCCM server under C:\SCCM Install Files\SQL Server 2017\SQLServerReportingServices.exe

Alternatively you can download it from this URL: https://www.microsoft.com/en-us/download/details.aspx?id=55252

If you download it now you can skip downloading it after the SQL installation is complete. We will install the Reporting Services immediately following the SQL Server 2017 installation.

Click Next. You may change the instance name or ID if you’d like - but we will use the defaults and click Next:

Click the drop-box next to the account names and click Browse. Note that you MUST change the account for the SQL Server Agent away from the default NT Service account. 

We are going to use the SQLService account we created earlier. Make sure you enter the passwords for the accounts.

Next click the Collation tab and verify that your database engine is using the SQL_Latin1_General_CP1_CI_AS collation setting.

Note: The default server collation setting SQL_Latin1_General_CP1_CI_AS is based upon your Windows Server Locale Settings. Simply stated if you are from the United States and you have your Windows Server Locale set correctly (United States -English), when you install SQL server your Server Collation settings by default will reflect SQL_Latin1_General_CP1_CI_AS. If you are from a Non-US English or even UK-English speaking country please verify this setting.

Sign up to access the rest of this lesson

You must either log in or sign up to access this lesson.

Saving Progress...

0 0 votes
Lesson Rating
Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments