Gary Blok

April 30, 2020

Building a CM Lab – ConfigMgr [MEMCM] Installing SQL [7]

Post 7, the favorite part of setting up your CM Server, Installing SQL. I dislike it so much that I’ve stolen a script to make it less painful.

So far, we’ve got our Gateway, DC and started to setup our ConfigMgr Lab Server, in this installment, I’ll be going over the SQL install for CM… on box.  For deeper dive into SQL recommendations, check out this WhitePaper

So to make this process easier and more shiny, I’m stealing a page out of Johan’s book, well it’s actually an unattend file from his blog, but you get it. For a step by step, you can follow this process based on SQL 2016.
Please note, depending on the version of SQL you install, it’s going to be different. I’m using 2019, which does not have Report Services, and will do a future post talking about Report Services Setup for CM.

I copied his unattend file, changed several of the paths from the drive letters he had to drive D: and then replaced the group viamonstra\administrators to dev\SQL_Admins

That worked so nicely, quickest way to install SQL I’ve ever done.. here are the parts I changed:

So I’ve downloaded SQL Server Management Studio from HERE, Lets get it installed.

Now back to the wonderful prereq tool to do a couple additional items. We can use this tool to confirm that SQL is up and running and set a few settings.

‍

Now at this point, things are progressing nicely, lets install WSUS. We needed to have SQL installed first, and now we can install WSUS to use the SQL Database.

‍

After you’ve done the WSUS setup in PreReq Tool, you can finish the setup on the Server

‍

Ok, so now we have everything ready to install ConfigMgr on this Server. Overall, not bad, pretty easy thanks to the community. Next we’ll start installing MEMCM!

‍

Blog Post List

Series Introduction – Building a CM Lab from Scratch

1. Domain Controller – Setting up your Domain Controller
2. Gateway Virtual Machine – Creating a Router for your Lab using Windows Server
3. Certificate Authority – On Domain Controller [Optional]
4. ConfigMgr Server Pre-Reqs (Windows Features)
5. Configuration Settings (AD & GPOs)
6. Source Server (File Share)
7. ConfigMgr SQL Install
8. ConfigMgr Install
9. ConfigMgr Basic Settings
10. ConfigMgr Collections & App Deployment
11. ConfigMgr OSD
12. ConfigMgr Reporting Services

‍

Related Resources

Building a CM Lab

Building a CM Lab – ConfigMgr [MEMCM] Server Pre-Reqs [4]

Building a CM Lab

Building a CM Lab – Cloud Management Gateway (CMG) – Certs PreReq [13]

Building a CM Lab

Building a CM Lab – Cloud Management Gateway (CMG) – Client CMG Endpoints [18]

Building a CM Lab

Building a CM Lab – Cloud Management Gateway (CMG) – Post CMG Config [17]

Building a CM Lab

Building a CM Lab – Cloud Management Gateway (CMG) – Azure Services Connection[15]

Building a CM Lab

Building a CM Lab – Cloud Management Gateway (CMG) – Azure Subscription [14]

Building a CM Lab

Building a CM Lab – Cloud Management Gateway (CMG) – Setting up CMG in the Console [16]

Building a CM Lab

Building a CM Lab – Certificate Authority [3]

Building a CM Lab

Building a CM Lab – ConfigMgr Collections / App Deployments [10]

Building a CM Lab

Building a CM Lab – ConfigMgr Settings Setup [9]

Building a CM Lab

Building a CM Lab – ConfigMgr Install [8]

Building a CM Lab

Building a CM Lab – ConfigMgr Source Share [6]

Building a CM Lab

Building a CM Lab – Configuration Settings (AD / GPO) [5]

Building a CM Lab

Building a CM Lab – Domain Controller VM [1]

Building a CM Lab

Building a CM Lab – Gateway VM [2]

Building a CM Lab

Building a CM Lab – SQL Reporting Services (SSRS) [12]

Building a CM Lab

Building a CM Lab – Operating System Deployment [11]

Building a CM Lab

Building a ConfigMgr Lab from Scratch – Series Intro