ConfigMgr Console

Building a ConfigMgr Lab from Scratch: Step 7 – Installing SQL for ConfigMgr

Topics: ConfigMgr Console

Building a ConfigMgr Lab from Scratch: Step 7

Installing SQL for ConfigMgr

This is 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 set up our ConfigMgr Lab Server, in this installment, I’ll be going over the SQL install for CM… on the box.

So to make this process easier and shinier, I’m stealing a page out of Johan’s book, well it’s actually an unattended file from his blog, but you get it. Step by step, you can follow this process based on SQL 2016.
Please note, that 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 unattended 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:

MEMCM Installing SQL
MEMCM Installing SQL
And after the process finished, which felt so fast I didn’t think it ran… but when I checked…
Uninstall or Change Program
Look, it’s all there.. just need to download and install SSMS

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

Microsoft SQL Server Management Studio
Microsoft sQL Server Management Studio
Microsoft SQL server Management Studio
Well, that was easy.

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

ConfigMgr Prerequisite Tools
First we point at the server with SQL installed, which happens to be the local host
ConfigMgr Prerequisite Tools
I’m using the tool to set the DB to 8GB, adjust for your environment.
ConfigMgr prerequisite Tools
And success!

ConfigMgr Prerequisite Tools
Confirming the Collation we set in the unattended, we’re good.

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

ConfigMgr Prerequisite Tools
The WSUS Tab
ConfigMgr Prerequisite Tools

ConfigMgr Prerequisite Tools
And now WSUS is installed.

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

WSUS Servers
I’ve placed the WSUSContent onto my E (Storage) Drive.
WSUS Servers

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!

Building a ConfigMgr Lab from Scratch Series

Series Introduction – Building a CM Lab from Scratch

  1. Setting up your Domain Controller
  2. 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 – You are Here
  8. ConfigMgr Install
  9. ConfigMgr Basic Settings
  10. ConfigMgr Collections & App Deployment
  11. ConfigMgr OSD
  12. ConfigMgr Reporting Services
  13. Cloud Management Gateway (CMG) – Certs PreReq
  14. Cloud Management Gateway (CMG) – Azure Subscription
  15. Azure Services Connection
  16. Setting up CMG in the Console
  17. Cloud Management Gateway (CMG) – Post CMG Config
  18. Cloud Management Gateway – Client CMG Endpoints
Back to Top